DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT dependencies on PAY_RUN_RESULTS

Line 147: ,pay_run_results rr

143: select scl.segment2 local_unit_id
144: ,rr.jurisdiction_code tax_mun_id
145: from per_all_assignments_f asg
146: ,hr_soft_coding_keyflex scl
147: ,pay_run_results rr
148: ,pay_element_types_f pet
149: where asg.assignment_id = l_assignment_id
150: and p_date_earned between asg.EFFECTIVE_START_DATE and asg.EFFECTIVE_END_DATE
151: and asg.SOFT_CODING_KEYFLEX_ID = scl.SOFT_CODING_KEYFLEX_ID

Line 169: ,pay_run_results rr

165: ,rr.jurisdiction_code tax_mun_id
166: FROM pay_assignment_actions assact
167: ,per_all_assignments_f asg
168: ,hr_soft_coding_keyflex scl
169: ,pay_run_results rr
170: WHERE assact.assignment_action_id = l_assignment_action_id
171: AND assact.assignment_id = asg.assignment_id
172: AND asg.assignment_id = l_assignment_id
173: AND p_date_earned BETWEEN asg.EFFECTIVE_START_DATE AND asg.EFFECTIVE_END_DATE