[Home] [Help]
9: g_basis_start date;
10: g_basis_year varchar2(4);
11: g_legal_entity_id varchar2(20);
12: g_person_id per_all_people_f.person_id%type;
13: g_assignment_set_id hr_assignment_sets.assignment_set_id%type;
14: g_setup_action_id pay_payroll_actions.payroll_action_id%type;
15: g_report_type varchar2(30);
16:
17: g_previous_person_id per_all_people_f.person_id%type;
80: v_next_action_id pay_assignment_actions.assignment_action_id%type;
81: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
82: v_assignment_id per_all_assignments_f.assignment_id%type;
83: v_person_id per_all_people_f.person_id%type;
84: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
85: --
86: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
88: ,pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
96: --
97: cursor process_assignments
98: (c_setup_action_id in pay_payroll_actions.payroll_action_id%type,
99: c_person_id in per_all_people_f.person_id%type,
100: c_assignment_set_id in hr_assignment_sets.assignment_set_id%type) is
101: select distinct pai.assignment_id
102: from pay_action_information pai
103: where pai.action_context_id = c_setup_action_id
104: and pai.action_context_type = 'AAP'
103: where pai.action_context_id = c_setup_action_id
104: and pai.action_context_type = 'AAP'
105: and pai.action_information_category = 'SG_IRAS_AMEND_SETUP'
106: and decode(c_assignment_set_id,null,'Y',
107: decode(hr_assignment_set.ASSIGNMENT_IN_SET(c_assignment_set_id,pai.assignment_id),'Y','Y','N')) = 'Y'
108: and action_information2 between p_start_person_id and p_end_person_id
109: and action_information2 = nvl(c_person_id,action_information2)
110: and exists (SELECT 1
111: FROM hr_organization_information