DBA Data[Home] [Help]

APPS.PER_EVS_MAG_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 555: SELECT pay_assignment_actions_s.nextval

551: if g_evs_category = 'EMPLOYEE' then
552: hr_utility.set_location(l_proc,20);
553: for asgrec in c_actions_ee(pactid,stperson, endperson) loop
554: hr_utility.trace('RK in c_actions_ee cursor');
555: SELECT pay_assignment_actions_s.nextval
556: INTO lockingactid
557: FROM dual;
558: -- insert the action record.
559: hr_nonrun_asact.insact(lockingactid,asgrec.assignment_id,pactid,chunk,

Line 568: SELECT pay_assignment_actions_s.nextval

564: hr_utility.set_location(l_proc,30);
565: hr_utility.trace('g_evs_category = NEWHIRE Satisfied ');
566: for asgrec in c_actions_nh(pactid,stperson, endperson) loop
567:
568: SELECT pay_assignment_actions_s.nextval
569: INTO lockingactid
570: FROM dual;
571:
572: -- insert the action record.

Line 584: SELECT pay_assignment_actions_s.nextval

580: elsif g_evs_category = 'RETIREE' then
581: hr_utility.set_location(l_proc,40);
582: for asgrec in c_actions_rt(pactid,stperson, endperson) loop
583:
584: SELECT pay_assignment_actions_s.nextval
585: INTO lockingactid
586: FROM dual;
587:
588: -- insert the action record.

Line 597: SELECT pay_assignment_actions_s.nextval

593: elsif g_evs_category = 'EMPRTR' then
594: hr_utility.set_location(l_proc,50);
595: for asgrec in c_actions_ee(pactid,stperson, endperson) loop
596:
597: SELECT pay_assignment_actions_s.nextval
598: INTO lockingactid
599: FROM dual;
600:
601: -- insert the action record.