APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 126: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE

122: -- Cursor definitions
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

Line 130: from pay_assignment_actions pact

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
132: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
133: and pact.TAX_UNIT_ID = p_tax_unit_id
134: and prt.LEGISLATION_CODE = 'NO'

Line 144: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE

140: ------------- Remove this
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

Line 148: from pay_assignment_actions pact

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
150: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
151: and pact.TAX_UNIT_ID = p_tax_unit_id
152: and prt.LEGISLATION_CODE = 'NO'