[Home] [Help]
386: sqlstr :=
387: 'SELECT '
388: || l_package
389: || ' (:p_person_id,:p_eff_date) '
390: || 'FROM DUAL';
391: hr_utility.set_location(sqlstr,1);
392: EXECUTE IMMEDIATE sqlstr into l_passport_number USING p_person_id,l_effective_date;
393: hr_utility.trace('Function value l_passport_number '||l_passport_number);
394: exception
966: and pbd.legislation_code = 'GB';
967:
968: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
969: is
970: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
971:
972: BEGIN
973: hr_utility.set_location('Entering: '||l_proc,1);
974: l_context_lst(1).tax_unit_id :=NULL;
1346: order by 2 desc;
1347:
1348: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
1349: is
1350: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
1351:
1352: cursor csr_reversal is
1353: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1354: where paa.assignment_action_id = p_last_asg_action_id
4269:
4270: if l_last_asg_action_id is not null then
4271: hr_utility.set_location('Creating assignment action for the assignment ID : '||asg_rec.assignment_id,20);
4272:
4273: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4274: -- Insert assignment into pay_assignment_actions
4275: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
4276:
4277: --Locking mechanism
4406:
4407: if l_last_asg_action_id is null then
4408: hr_utility.set_location('Creating assignment action for the assignment ID : '||l_ni_rpt_asg_id,20);
4409:
4410: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4411: -- Insert assignment into pay_assignment_actions
4412: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
4413:
4414: --NI Aggr