APPS.PAY_NL_SI_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 533: FROM pay_assignment_actions

529: ,p_assignment_action_id IN NUMBER) RETURN number IS
530: --
531: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
532: SELECT payroll_action_id
533: FROM pay_assignment_actions
534: WHERE assignment_action_id = c_assignment_action_id;
535: --
536: l_payroll_action_id number;
537: l_part_time_perc varchar2(35);

Line 606: FROM pay_assignment_actions

602: ,p_assignment_action_id IN NUMBER) RETURN number IS
603: --
604: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
605: SELECT payroll_action_id
606: FROM pay_assignment_actions
607: WHERE assignment_action_id = c_assignment_action_id;
608: --
609: l_payroll_action_id number;
610: l_part_time_perc varchar2(35);

Line 680: FROM pay_assignment_actions

676: ,p_assignment_action_id IN NUMBER) RETURN number IS
677: --
678: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
679: SELECT payroll_action_id
680: FROM pay_assignment_actions
681: WHERE assignment_action_id = c_assignment_action_id;
682: --
683: l_payroll_action_id number;
684: l_part_time_perc varchar2(35);

Line 754: FROM pay_assignment_actions

750: ,p_assignment_action_id IN NUMBER) RETURN number IS
751: --
752: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
753: SELECT payroll_action_id
754: FROM pay_assignment_actions
755: WHERE assignment_action_id = c_assignment_action_id;
756: --
757: l_payroll_action_id number;
758: l_part_time_perc varchar2(35);

Line 827: FROM pay_assignment_actions

823: ,p_assignment_action_id IN NUMBER) RETURN number IS
824: --
825: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
826: SELECT payroll_action_id
827: FROM pay_assignment_actions
828: WHERE assignment_action_id = c_assignment_action_id;
829: --
830: l_payroll_action_id number;
831: l_part_time_perc varchar2(35);