DBA Data[Home] [Help]

APPS.PAY_GB_WNU_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 220: hr_soft_coding_keyflex hsck,

216: --
217: cursor csr_agg_assignment is
218: select min(aaf.assignment_id) assignment_id
219: from per_all_assignments_f aaf,
220: hr_soft_coding_keyflex hsck,
221: pay_all_payrolls_f papf,
222: per_assignment_status_types past
223: where aaf.person_id = p_person_id
224: AND p_effective_date between

Line 234: FROM hr_soft_coding_keyflex hsck2,

230: AND past.per_system_status='ACTIVE_ASSIGN'
231: AND p_effective_date BETWEEN aaf.effective_start_date AND aaf.effective_end_date
232: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
233: AND hsck.segment1 in ( SELECT distinct(hsck.segment1)
234: FROM hr_soft_coding_keyflex hsck2,
235: pay_all_payrolls_f papf2,
236: per_all_assignments_f paaf,
237: per_assignment_status_types past2
238: WHERE hsck2.soft_coding_keyflex_id = papf2.soft_coding_keyflex_id