DBA Data[Home] [Help]

APPS.PAY_IE_WNU_EDI dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 185: from HR_ASSIGNMENT_SET_AMENDMENTS amend,

181: and pay.payroll_id = NVL(p_payroll_id,pay.payroll_id)
182: and (p_assignment_set_id is null
183: OR exists
184: ( select 1
185: from HR_ASSIGNMENT_SET_AMENDMENTS amend,
186: hr_assignment_sets aset
187: where
188: ( P_ASSIGNMENT_SET_ID IS NOT NULL and
189: aset.assignment_set_id = P_ASSIGNMENT_SET_ID

Line 344: from HR_ASSIGNMENT_SET_AMENDMENTS amend,

340: and pay.payroll_id = NVL(p_payroll_id,pay.payroll_id)
341: and (p_assignment_set_id is null
342: OR exists
343: ( select 1
344: from HR_ASSIGNMENT_SET_AMENDMENTS amend,
345: hr_assignment_sets aset
346: where
347: ( P_ASSIGNMENT_SET_ID IS NOT NULL and
348: aset.assignment_set_id = P_ASSIGNMENT_SET_ID