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

Line 100: from pay_action_information pai

96: from dual;
97: --
98: cursor process_assignments ( c_setup_action_id in pay_payroll_actions.payroll_action_id%type ) is
99: select distinct pai.assignment_id
100: from pay_action_information pai
101: where pai.action_context_id = c_setup_action_id
102: and pai.action_context_type = 'AAP'
103: and pai.action_information_category = 'SG_IRAS_SETUP'
104: and action_information2 between p_start_person_id and p_end_person_id ;

Line 4400: -- Bug: 3910804 Delete data from pay_action_information

4396: into v_setup_action
4397: from pay_payroll_actions
4398: where payroll_action_id = p_payroll_action_id ;
4399: -------------------------------------------------------
4400: -- Bug: 3910804 Delete data from pay_action_information
4401: -------------------------------------------------------
4402: delete from pay_action_information
4403: where action_context_id = v_setup_action
4404: and action_context_type = 'AAP'

Line 4402: delete from pay_action_information

4398: where payroll_action_id = p_payroll_action_id ;
4399: -------------------------------------------------------
4400: -- Bug: 3910804 Delete data from pay_action_information
4401: -------------------------------------------------------
4402: delete from pay_action_information
4403: where action_context_id = v_setup_action
4404: and action_context_type = 'AAP'
4405: and action_information_category = 'SG_IRAS_SETUP';
4406:

Line 4437: from pay_action_information pai

4433: if p_national_identifier is not null and p_report_type <> 'SG_IR8S_ADHOC_REPORT' then
4434: begin
4435: select distinct pai.action_information2 , fnd_date.canonical_to_date(pai.action_information3)
4436: bulk collect into g_person_id_tab , g_person_start_date_tab
4437: from pay_action_information pai
4438: where pai.action_information1 = p_national_identifier
4439: and pai.action_context_id = p_setup_action_id
4440: and pai.action_context_type = 'AAP'
4441: and pai.action_information_category = 'SG_IRAS_SETUP'