DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_RUN_TYPES_F

Line 213: ,pay_run_types_f prt

209: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
210: ,p_date_earned DATE ) is
211: select pact.ASSIGNMENT_ACTION_ID
212: from pay_assignment_actions pact
213: ,pay_run_types_f prt
214: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
215: and pact.TAX_UNIT_ID = p_tax_unit_id
216: and prt.LEGISLATION_CODE = 'NO'
217: and prt.RUN_TYPE_NAME = 'Employer Contributions'

Line 231: ,pay_run_types_f prt

227: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
228: ,p_date_earned DATE ) is
229: select count(*)
230: from pay_assignment_actions pact
231: ,pay_run_types_f prt
232: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
233: and pact.TAX_UNIT_ID = p_tax_unit_id
234: and prt.LEGISLATION_CODE = 'NO'
235: and prt.RUN_TYPE_NAME = 'Employer Contributions'