DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT dependencies on PAY_PAYROLL_ACTIONS

Line 135: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type

131:
132: -- csr to get the current assignment_action_ids with the same LE
133: cursor csr_curr_le_asg_act_id
134: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
135: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
136: ,p_date_earned DATE ) is
137: select pact.ASSIGNMENT_ACTION_ID
138: from pay_assignment_actions pact
139: ,pay_run_types_f prt

Line 153: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type

149: -- testing the number of rows returned by the above cursor
150: -- csr to get the current assignment_action_ids with the same LE
151: cursor csr_test_aag_act_id
152: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
153: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
154: ,p_date_earned DATE ) is
155: select count(*)
156: from pay_assignment_actions pact
157: ,pay_run_types_f prt