DBA Data[Home] [Help]

APPS.PAY_CORE_PAYSLIP_UTILS dependencies on STANDARD

Line 386: l_standard_asg_act_id pay_assignment_actions.assignment_action_id%type;

382: l_sequence NUMBER;
383:
384: l_proc VARCHAR2(50) := g_package || 'archive_code';
385:
386: l_standard_asg_act_id pay_assignment_actions.assignment_action_id%type;
387: l_pactid pay_assignment_actions.payroll_action_id%type;
388:
389: BEGIN
390:

Line 405: l_standard_asg_act_id := null;

401: l_pactid
402: FROM pay_assignment_actions paa
403: WHERE paa.assignment_action_id = p_assactid;
404:
405: l_standard_asg_act_id := null;
406:
407: -- Select all the master run actions.
408: FOR csr_rec IN csr_assignment_actions(p_assactid)
409:

Line 474: if (l_standard_asg_act_id is null) then

470: IF csr_child_rec.run_type = 'NP'
471:
472: THEN
473:
474: if (l_standard_asg_act_id is null) then
475: --
476: SELECT pay_assignment_actions_s.NEXTVAL
477: INTO l_actid
478: FROM dual;

Line 495: l_standard_asg_act_id := l_actid;

491: , prepayid => NULL
492: , status => 'C'
493: , source_act => p_assactid);
494: --
495: l_standard_asg_act_id := l_actid;
496: --
497: else
498: --
499: l_actid := l_standard_asg_act_id;

Line 499: l_actid := l_standard_asg_act_id;

495: l_standard_asg_act_id := l_actid;
496: --
497: else
498: --
499: l_actid := l_standard_asg_act_id;
500: --
501: end if;
502: --
503: FOR csr_np_rec IN csr_np_children(csr_rec.master_assignment_action_id,