APPS.PAY_NL_SI_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 550: FROM pay_assignment_actions

546: ,p_assignment_action_id IN NUMBER) RETURN number IS
547: --
548: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
549: SELECT payroll_action_id
550: FROM pay_assignment_actions
551: WHERE assignment_action_id = c_assignment_action_id;
552: --
553: l_payroll_action_id number;
554: l_part_time_perc varchar2(35);

Line 623: FROM pay_assignment_actions

619: ,p_assignment_action_id IN NUMBER) RETURN number IS
620: --
621: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
622: SELECT payroll_action_id
623: FROM pay_assignment_actions
624: WHERE assignment_action_id = c_assignment_action_id;
625: --
626: l_payroll_action_id number;
627: l_part_time_perc varchar2(35);

Line 697: FROM pay_assignment_actions

693: ,p_assignment_action_id IN NUMBER) RETURN number IS
694: --
695: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
696: SELECT payroll_action_id
697: FROM pay_assignment_actions
698: WHERE assignment_action_id = c_assignment_action_id;
699: --
700: l_payroll_action_id number;
701: l_part_time_perc varchar2(35);

Line 771: FROM pay_assignment_actions

767: ,p_assignment_action_id IN NUMBER) RETURN number IS
768: --
769: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
770: SELECT payroll_action_id
771: FROM pay_assignment_actions
772: WHERE assignment_action_id = c_assignment_action_id;
773: --
774: l_payroll_action_id number;
775: l_part_time_perc varchar2(35);

Line 844: FROM pay_assignment_actions

840: ,p_assignment_action_id IN NUMBER) RETURN number IS
841: --
842: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
843: SELECT payroll_action_id
844: FROM pay_assignment_actions
845: WHERE assignment_action_id = c_assignment_action_id;
846: --
847: l_payroll_action_id number;
848: l_part_time_perc varchar2(35);