[Home] [Help]
66: ------------------------------------------------------------------------
67: function net_accrual
68: (p_assignment_id in pay_assignment_actions.assignment_id%type,
69: p_plan_id in pay_accrual_plans.accrual_plan_id%type,
70: p_payroll_id in pay_payroll_actions.payroll_id%type,
71: p_business_group_id in pay_accrual_plans.business_group_id%type,
72: p_effective_date in per_time_periods.end_date%type)
73: return number is
74: v_start_date date;
167: cursor c_lock_id
168: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is
169: select pai.locking_action_id
170: from pay_action_interlocks pai,
171: pay_payroll_actions ppa,
172: pay_assignment_actions paa
173: where pai.locked_action_id = c_assign_act_id
174: and paa.assignment_action_id=pai.locking_action_id
175: and ppa.payroll_action_id=paa.payroll_action_id
179: /* Bug #2824397 */
180: /* Bug:2824397 Added extra parameter c_date_earned */
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
189:
190: cursor c_date_earned
191: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
192: select ppa.effective_date /* Bug 4267365 */
193: from pay_payroll_actions ppa,
194: pay_assignment_actions pac
195: where pac.payroll_action_id = ppa.payroll_action_id
196: and pac.assignment_action_id = c_assignment_action_id;
197:
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,
204: pay_payroll_actions ppa
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
208: and pac.payroll_action_id = ppa.payroll_action_id
399: cursor c_lock_id
400: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is
401: select pai.locking_action_id
402: from pay_action_interlocks pai,
403: pay_payroll_actions ppa,
404: pay_assignment_actions paa
405: where pai.locked_action_id = c_assign_act_id
406: and paa.assignment_action_id=pai.locking_action_id
407: and ppa.payroll_action_id=paa.payroll_action_id
410: /* Bug #2824397 */
411: /* Bug:2824397 Added extra parameter c_date_earned */
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
420:
421: cursor c_date_earned
422: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
423: select ppa.effective_date /* Bug 4267365 */
424: from pay_payroll_actions ppa,
425: pay_assignment_actions pac
426: where pac.payroll_action_id = ppa.payroll_action_id
427: and pac.assignment_action_id = c_assignment_action_id;
428:
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,
435: pay_payroll_actions ppa
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
439: and pac.payroll_action_id = ppa.payroll_action_id
1012: -- to a payroll
1013: ------------------------------------------------------------------------
1014: function get_payroll_currency_code
1015: (p_payroll_id in pay_payrolls_f.payroll_id%type,
1016: p_effective_date in pay_payroll_actions.effective_date%type)
1017: return fnd_currencies.currency_code%type is
1018:
1019: v_currency_code fnd_currencies.currency_code%type;
1020:
1019: v_currency_code fnd_currencies.currency_code%type;
1020:
1021: cursor csr_currency_code
1022: (c_payroll_id pay_assignment_actions.assignment_action_id%type,
1023: c_effective_date in pay_payroll_actions.effective_date%type) is
1024: select popm.currency_code
1025: from pay_payrolls_f ppf,
1026: pay_org_payment_methods_f popm
1027: where ppf.payroll_id = c_payroll_id
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;
1052: v_payroll_id pay_payrolls_f.payroll_id%type;
1052: v_payroll_id pay_payrolls_f.payroll_id%type;
1053:
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;