DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 8: FROM pay_element_entries_f, pay_element_types_f , per_all_assignments_f,PER_ASSIGNMENT_STATUS_TYPES PAST

4:
5:
6: CURSOR cur_element_entry_assignment (p_end_date date,p_payroll_id pay_all_payrolls_f.payroll_id%type) IS
7: SELECT pay_element_entries_f.element_entry_id element_entry_id, per_all_assignments_f.assignment_id assignment_id
8: FROM pay_element_entries_f, pay_element_types_f , per_all_assignments_f,PER_ASSIGNMENT_STATUS_TYPES PAST
9: WHERE pay_element_entries_f.element_type_id = pay_element_types_f.element_type_id
10: AND per_all_assignments_f.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
11: AND PAST.PER_SYSTEM_STATUS ='ACTIVE_ASSIGN'
12: and pay_element_entries_f.assignment_id = per_all_assignments_f.assignment_id