DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_PAYROLL_ACTIONS

Line 127: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type

123:
124: -- csr to get the current assignment_action_ids with the same LE
125: cursor csr_curr_le_asg_act_id
126: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
127: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
128: ,p_date_earned DATE ) is
129: select pact.ASSIGNMENT_ACTION_ID
130: from pay_assignment_actions pact
131: ,pay_run_types_f prt

Line 145: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type

141: -- testing the number of rows returned by the above cursor
142: -- csr to get the current assignment_action_ids with the same LE
143: cursor csr_test_aag_act_id
144: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
145: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
146: ,p_date_earned DATE ) is
147: select count(*)
148: from pay_assignment_actions pact
149: ,pay_run_types_f prt