eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on PER_ALL_ASSIGNMENTS_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 10: AND per_all_assignments_f.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID

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'
14: and per_all_assignments_f.payroll_id = p_payroll_id

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 14: and per_all_assignments_f.payroll_id = p_payroll_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
17: and p_end_date between per_all_assignments_f.effective_start_date and per_all_assignments_f.effective_end_date;
18:

Line 17: and p_end_date between per_all_assignments_f.effective_start_date and per_all_assignments_f.effective_end_date;

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
20: select
21: MAX(DECODE ( name , 'Qualifying Scheme Name', INPUT_VALUE_ID )) qualifying_scheme_name,

Line 56: cursor cur_person_assign_num(p_assignment_id per_all_assignments_f.assignment_id%type,p_end_date date) is

52: where element_entry_id = p_elem_entry_id
53: and p_end_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
54: );
55:
56: cursor cur_person_assign_num(p_assignment_id per_all_assignments_f.assignment_id%type,p_end_date date) is
57: SELECT assignment_number,person_id
58: FROM per_all_assignments_f
59: WHERE assignment_id = p_assignment_id
60: AND p_end_date between effective_start_date and effective_end_date;

Line 58: FROM per_all_assignments_f

54: );
55:
56: cursor cur_person_assign_num(p_assignment_id per_all_assignments_f.assignment_id%type,p_end_date date) is
57: SELECT assignment_number,person_id
58: FROM per_all_assignments_f
59: WHERE assignment_id = p_assignment_id
60: AND p_end_date between effective_start_date and effective_end_date;
61:
62: cursor cur_get_input_time(p_period number,p_payroll_id per_time_periods.payroll_id%type) is