[Home] [Help]
99: from dual;
100: --
101: cursor process_assignments ( c_setup_action_id in pay_payroll_actions.payroll_action_id%type ) is
102: select distinct pai.assignment_id
103: from pay_action_information pai
104: where pai.action_context_id = c_setup_action_id
105: and pai.action_context_type = 'AAP'
106: and pai.action_information_category = 'SG_IRAS_SETUP'
107: and action_information2 between p_start_person_id and p_end_person_id ;
4656: into v_setup_action
4657: from pay_payroll_actions
4658: where payroll_action_id = p_payroll_action_id ;
4659: -------------------------------------------------------
4660: -- Bug: 3910804 Delete data from pay_action_information
4661: -------------------------------------------------------
4662: delete from pay_action_information
4663: where action_context_id = v_setup_action
4664: and action_context_type = 'AAP'
4658: where payroll_action_id = p_payroll_action_id ;
4659: -------------------------------------------------------
4660: -- Bug: 3910804 Delete data from pay_action_information
4661: -------------------------------------------------------
4662: delete from pay_action_information
4663: where action_context_id = v_setup_action
4664: and action_context_type = 'AAP'
4665: and action_information_category = 'SG_IRAS_SETUP';
4666:
4693: if p_national_identifier is not null and p_report_type <> 'SG_IR8S_ADHOC_REPORT' then
4694: begin
4695: select distinct pai.action_information2 , fnd_date.canonical_to_date(pai.action_information3)
4696: bulk collect into g_person_id_tab , g_person_start_date_tab
4697: from pay_action_information pai
4698: where pai.action_information1 = p_national_identifier
4699: and pai.action_context_id = p_setup_action_id
4700: and pai.action_context_type = 'AAP'
4701: and pai.action_information_category = 'SG_IRAS_SETUP'