Basic Payroll Tables and their links

Basic Payroll Tables and their links, askhareesh blog for Oracle Apps

SELECT * FROM PAY_ELEMENT_TYPES_F(PK: ELEMENT_TYPE_ID)

SELECT * FROM PAY_ELEMENT_LINKS_F(PK: ELEMENT_LINK_ID)
                                  (To link PAY_ELEMENT_TYPES_F:ELEMENT_TYPE_ID)

SELECT * FROM PAY_ELEMENT_ENTRIES_F (PK: ELEMENT_ENTRY_ID)
                                    (To link PER_ALL_ASSIGNMENTS_F :ASSIGNMENT_ID,
                                     PAY_ELEMENT_LINKS_F :ELEMENT_LINK_ID,
                                     PAY_ELEMENT_TYPES_F :ELEMENT_TYPE_ID)
                                                                   
SELECT * FROM PAY_ELEMENT_ENTRY_VALUES_F (PK:ELEMENT_ENTRY_VALUE_ID)
                                         (To link PAY_ELEMENT_ENTRIES_F : ELEMENT_ENTRY_ID,
                                          PAY_RUN_RESULT_VALUES : INPUT_VALUE_ID,
                                          PAY_COSTS : INPUT_VALUE_ID)                                                                  

select * from PER_ALL_PEOPLE_F (PK:PERSON_ID)  

select * from PER_ALL_ASSIGNMENTS_F (PK:ASSIGNMENT_ID)
                                    (To link PER_ALL_PEOPLE_F:PERSON_ID,
                                     PER_JOBS:JOB_ID,
                                     PER_GRADES:GRADE_ID,
                                     PER_POSITIONS : POSITION_ID,
                                     PER_BUSINESS_GROUPS:BUSINESS_GROUP_ID,
                                     PER_ASSIGNMENT_STATUS_TYPES:ASSIGNMENT_STATUS_TYPE_ID,
                                     HR_LOCATIONS :LOCATION_ID,
                                     PAY_PAYROLLS_F : PAYROLL_ID)
                                                             
SELECT * FROM PER_PERSON_TYPE_USAGES_F (PK: PERSON_TYPE_USAGE_ID)
                                        (To link  PER_ALL_PEOPLE_F: PERSON_ID,
                                         PER_PERSON_TYPES:PERSON_TYPE_ID)

SELECT * FROM PER_PERSON_TYPES  (PK:PERSON_TYPE_ID)
                                 (To link  PER_PERSON_TYPE_USAGES_F : PERSON_TYPE_ID)



*/

No comments:

Post a Comment