DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT dependencies on PAY_RUN_TYPES_F

Line 139: ,pay_run_types_f prt

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
140: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
141: and pact.TAX_UNIT_ID = p_tax_unit_id
142: and prt.LEGISLATION_CODE = 'NO'
143: and prt.RUN_TYPE_NAME = 'Employer Contributions'

Line 157: ,pay_run_types_f prt

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
158: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
159: and pact.TAX_UNIT_ID = p_tax_unit_id
160: and prt.LEGISLATION_CODE = 'NO'
161: and prt.RUN_TYPE_NAME = 'Employer Contributions'