[Home] [Help]
127: v_ass_act_id pay_assignment_actions.assignment_action_id%type;
128: v_asg_le_value number;
129: v_counter number := 1;
130:
131: TYPE assign_tab is table of per_all_assignments_f.assignment_id%type
132: index by BINARY_INTEGER;
133:
134: assignment_table assign_tab;
135:
181: cursor c_check_assignment
182: (c_person_id per_all_people_f.person_id%type,
183: c_date_earned pay_payroll_actions.date_earned%type) is
184: select distinct assignment_id
185: from per_all_assignments_f
186: where person_id = c_person_id
187: and effective_start_date <= c_date_earned
188: and assignment_type = 'E';
189:
195: where pac.payroll_action_id = ppa.payroll_action_id
196: and pac.assignment_action_id = c_assignment_action_id;
197:
198: cursor c_max_assign_action
199: (c_assignment_id per_all_assignments_f.assignment_id%type,
200: c_date_earned pay_payroll_actions.date_earned%type ) is
201: select max(pac.assignment_action_id)
202: from pay_assignment_actions pac,
203: per_all_assignments_f paa,
199: (c_assignment_id per_all_assignments_f.assignment_id%type,
200: c_date_earned pay_payroll_actions.date_earned%type ) is
201: select max(pac.assignment_action_id)
202: from pay_assignment_actions pac,
203: per_all_assignments_f paa,
204: pay_payroll_actions ppa
205: where paa.assignment_id = c_assignment_id
206: and paa.assignment_type = 'E'
207: and paa.assignment_id = pac.assignment_id
362: v_ass_act_id pay_assignment_actions.assignment_action_id%type;
363: v_asg_le_value number;
364: v_counter number := 1;
365:
366: TYPE assign_tab is table of per_all_assignments_f.assignment_id%type
367: index by BINARY_INTEGER;
368:
369: assignment_table assign_tab;
370:
412: cursor c_check_assignment
413: (c_person_id per_all_people_f.person_id%type,
414: c_date_earned pay_payroll_actions.date_earned%type ) is
415: select distinct assignment_id
416: from per_all_assignments_f
417: where person_id = c_person_id
418: and effective_start_date <= c_date_earned
419: and assignment_type = 'E';
420:
426: where pac.payroll_action_id = ppa.payroll_action_id
427: and pac.assignment_action_id = c_assignment_action_id;
428:
429: cursor c_max_assign_action
430: (c_assignment_id per_all_assignments_f.assignment_id%type,
431: c_date_earned pay_payroll_actions.date_earned%type ) is
432: select max(pac.assignment_action_id)
433: from pay_assignment_actions pac,
434: per_all_assignments_f paa,
430: (c_assignment_id per_all_assignments_f.assignment_id%type,
431: c_date_earned pay_payroll_actions.date_earned%type ) is
432: select max(pac.assignment_action_id)
433: from pay_assignment_actions pac,
434: per_all_assignments_f paa,
435: pay_payroll_actions ppa
436: where paa.assignment_id = c_assignment_id
437: and paa.assignment_type = 'E'
438: and paa.assignment_id = pac.assignment_id
1043: -- Bug#5633652 - Returns currency code based on the payroll attached
1044: -- to an assignment
1045: ------------------------------------------------------------------------
1046: function get_assignment_currency_code
1047: (p_assignment_id in per_all_assignments_f.assignment_id%type,
1048: p_effective_date in pay_payroll_actions.effective_date%type)
1049: return fnd_currencies.currency_code%type is
1050:
1051: v_currency_code fnd_currencies.currency_code%type;
1054: cursor csr_get_payroll_id
1055: (c_assignment_id pay_assignment_actions.assignment_action_id%type,
1056: c_effective_date in pay_payroll_actions.effective_date%type) is
1057: select payroll_id
1058: from per_all_assignments_f
1059: where assignment_id = c_assignment_id
1060: and c_effective_date between effective_start_date and effective_end_date;
1061:
1062: begin