APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on PAY_ELEMENT_ENTRIES_F

Line 7: SELECT pay_element_entries_f.element_entry_id element_entry_id, per_all_assignments_f.assignment_id assignment_id

3: AS
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'

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

Line 9: WHERE pay_element_entries_f.element_type_id = pay_element_types_f.element_type_id

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
13: and pay_element_types_f.ELEMENT_NAME like 'Pensions Information'

Line 12: and pay_element_entries_f.assignment_id = per_all_assignments_f.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
13: and pay_element_types_f.ELEMENT_NAME like 'Pensions Information'
14: and per_all_assignments_f.payroll_id = p_payroll_id
15: and p_end_date between pay_element_entries_f.effective_start_date and pay_element_entries_f.effective_end_date
16: and p_end_date between pay_element_types_f.effective_start_date and pay_element_types_f.effective_end_date

Line 15: and p_end_date between pay_element_entries_f.effective_start_date and pay_element_entries_f.effective_end_date

11: AND PAST.PER_SYSTEM_STATUS ='ACTIVE_ASSIGN'
12: and pay_element_entries_f.assignment_id = per_all_assignments_f.assignment_id
13: and pay_element_types_f.ELEMENT_NAME like 'Pensions Information'
14: and per_all_assignments_f.payroll_id = p_payroll_id
15: and p_end_date between pay_element_entries_f.effective_start_date and pay_element_entries_f.effective_end_date
16: and p_end_date between pay_element_types_f.effective_start_date and pay_element_types_f.effective_end_date
17: and p_end_date between per_all_assignments_f.effective_start_date and per_all_assignments_f.effective_end_date;
18:
19: cursor cur_input_id is