DBA Data[Home] [Help]

APPS.PER_MM_POSITIONS_PKG dependencies on HR_POSITIONS

Line 154: from hr_positions pos,

150: 'P',
151: 'N',
152: 'N',
153: 'N'
154: from hr_positions pos,
155: per_organization_units org,
156: per_jobs job
157: where pos.job_id = job.job_id
158: and pos.organization_id = org.organization_id

Line 498: from hr_positions pos

494: l_dummy number(15);
495:
496: cursor c is
497: select pos.organization_id
498: from hr_positions pos
499: where p_new_position_definition_id = pos.position_definition_id
500: and pos.organization_id <> p_new_organization_id;
501:
502: begin

Line 531: from hr_positions pos,

527: pos.position_id,
528: job.name,
529: job.job_id,
530: job.job_definition_id
531: from hr_positions pos,
532: per_jobs job
533: where p_new_position_definition_id = pos.position_definition_id
534: and pos.job_id = job.job_id;
535: