DBA Data[Home] [Help]

APPS.PAY_PEL_BUS dependencies on HR_ORGANIZATION_UNITS

Line 1011: from per_positions pos, per_jobs job, hr_organization_units org

1007: l_dummy varchar2(1);
1008:
1009: cursor csr_position is
1010: select 'X'
1011: from per_positions pos, per_jobs job, hr_organization_units org
1012: where pos.position_id = p_position_id
1013: and pos.business_group_id +0 = p_business_group_id
1014: and job.job_id = pos.job_id and org.organization_id = pos.organization_id
1015: and p_effective_date between pos.date_effective