DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_RUN_TYPES_F

Line 86: ,pay_run_types_f prt

82:
83: cursor csr_payroll_action_id (p_date_earned DATE ) is
84: select ppa.PAYROLL_ACTION_ID
85: from pay_payroll_actions ppa
86: ,pay_run_types_f prt
87: where ppa.RUN_TYPE_ID = prt.RUN_TYPE_ID
88: and prt.LEGISLATION_CODE = 'NO'
89: and prt.RUN_TYPE_NAME IN ('Main','Standard','Process Alone','Pay Separately')
90: and p_date_earned between prt.EFFECTIVE_START_DATE and prt.EFFECTIVE_END_DATE

Line 135: ,pay_run_types_f prt

131: ,p_date_earned DATE ) is
132:
133: SELECT scl.segment2 loc_unit , assact.tax_unit_id leg_emp
134: FROM pay_assignment_actions assact
135: ,pay_run_types_f prt
136: ,per_all_assignments_f asg
137: ,hr_soft_coding_keyflex scl
138: WHERE assact.PAYROLL_ACTION_ID = p_payroll_action_id
139: and prt.LEGISLATION_CODE = 'NO'