DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_RUN_TYPES_F

Line 131: ,pay_run_types_f prt

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'
135: and prt.RUN_TYPE_NAME = 'Employer Contributions'

Line 149: ,pay_run_types_f prt

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'
153: and prt.RUN_TYPE_NAME = 'Employer Contributions'