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_RTI_EYU dependencies on PAY_ACTION_INFORMATION

Line 2059: from pay_assignment_actions paa , pay_action_information pai

2055: (ACTION_INFORMATION20),
2056: (ACTION_INFORMATION21),
2057: (ACTION_INFORMATION22)
2058:
2059: from pay_assignment_actions paa , pay_action_information pai
2060: where paa.payroll_action_id = pactid
2061: and paa.ASSIGNMENT_ID = p_asg_id
2062: and pai.action_context_id = paa.assignment_action_id
2063: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_ASG_DET2'

Line 2076: from pay_assignment_actions paa , pay_action_information pai

2072: (ACTION_INFORMATION19),
2073: (ACTION_INFORMATION20),
2074: (ACTION_INFORMATION21),
2075: (ACTION_INFORMATION22)
2076: from pay_assignment_actions paa , pay_action_information pai
2077: where paa.payroll_action_id = pactid
2078: and paa.ASSIGNMENT_ID in (select distinct assignment_id from per_all_assignments_f where person_id = p_archive_tab(0).person_id)
2079: and pai.action_context_id = paa.assignment_action_id
2080: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_ASG_DET2'

Line 2096: from pay_assignment_actions paa , pay_action_information pai

2092: (ACTION_INFORMATION19),
2093: (ACTION_INFORMATION20),
2094: (ACTION_INFORMATION21),
2095: (ACTION_INFORMATION22)
2096: from pay_assignment_actions paa , pay_action_information pai
2097: where paa.payroll_action_id = pactid
2098: and paa.ASSIGNMENT_ID = p_asg_id
2099: and pai.action_context_id = paa.assignment_action_id
2100: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_EYU_ASG_DET'

Line 2236: from pay_assignment_actions paa , pay_action_information pai

2232: (ACTION_INFORMATION5) l_uap,
2233: (ACTION_INFORMATION6) l_uel,
2234: (ACTION_INFORMATION7) l_emr,
2235: (ACTION_INFORMATION8) l_emp
2236: from pay_assignment_actions paa , pay_action_information pai
2237: where paa.payroll_action_id = pactid
2238: and paa.ASSIGNMENT_ID = p_asg_id
2239: and pai.action_context_id = paa.assignment_action_id
2240: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_NI_DET'

Line 2319: from pay_assignment_actions paa , pay_action_information pai

2315:
2316: cursor csr_get_latest_fps_asg is
2317: select
2318: pai.assignment_id
2319: from pay_assignment_actions paa , pay_action_information pai
2320: where paa.payroll_action_id = pactid
2321: and paa.ASSIGNMENT_ID in (select distinct assignment_id from per_all_assignments_f where person_id = p_person_id)
2322: and pai.action_context_id = paa.assignment_action_id
2323: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_ASG_DET2'

Line 2337: from pay_assignment_actions paa , pay_action_information pai

2333: (ACTION_INFORMATION5) l_uap,
2334: (ACTION_INFORMATION6) l_uel,
2335: (ACTION_INFORMATION7) l_emr,
2336: (ACTION_INFORMATION8) l_emp
2337: from pay_assignment_actions paa , pay_action_information pai
2338: where paa.payroll_action_id = pactid
2339: and paa.ASSIGNMENT_ID = l_latest_fps_asg
2340: and pai.action_context_id = paa.assignment_action_id
2341: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_NI_DET'

Line 3705: -- Procedure to insert data to the archive table pay_action_information

3701: RETURN l_ovn;
3702: hr_utility.set_location('Leaving: '||l_proc,999);
3703: END;
3704:
3705: -- Procedure to insert data to the archive table pay_action_information
3706: PROCEDURE insert_archive_row
3707: (
3708: p_assactid IN NUMBER,
3709: p_effective_date IN DATE,

Line 3729: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,

3725: )
3726: ;
3727: hr_utility.trace('action_context_id = '|| p_assactid);
3728: IF p_tab_rec_data(i).action_info_category IS NOT NULL THEN
3729: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,
3730: p_object_version_number => l_ovn,
3731: p_action_information_category => p_tab_rec_data(i).action_info_category,
3732: p_action_context_id => p_assactid,
3733: p_action_context_type => 'AAP',

Line 6144: delete from pay_action_information pai

6140: BEGIN
6141: hr_utility.trace('Entering deinit: '||l_proc);
6142:
6143: -- To avoid re-archiving while Retry
6144: delete from pay_action_information pai
6145: where pai.action_context_id = pactid
6146: and pai.action_context_type = 'PA'
6147: and pai.action_information_category in ('RTI PAYROLL INFO');
6148:

Line 6149: delete from pay_action_information pai

6145: where pai.action_context_id = pactid
6146: and pai.action_context_type = 'PA'
6147: and pai.action_information_category in ('RTI PAYROLL INFO');
6148:
6149: delete from pay_action_information pai
6150: where pai.action_context_id = pactid
6151: and pai.action_context_type = 'PA'
6152: and pai.action_information_category in ('GB_RTI_FPS_EXTRA_DET');
6153:

Line 6173: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,

6169: hr_utility.set_location('g_start_year = '||g_start_year,60);
6170:
6171: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
6172:
6173: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,
6174: p_action_context_id => pactid ,
6175: p_action_context_type => 'PA' ,
6176: p_object_version_number => l_ovn ,
6177: p_source_id => NULL ,

Line 6192: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,

6188: p_action_information13 => l_payroll_rec.test_indicator ,
6189: p_action_information14 => TO_CHAR(l_payroll_rec.request_id),
6190: p_action_information15 => to_char(g_end_year,'RRRR'));
6191: ---
6192: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,
6193: p_action_context_id => pactid ,
6194: p_action_context_type => 'PA' ,
6195: p_object_version_number => l_ovn ,
6196: p_source_id => NULL ,