APPS.PA_CROSS_BUSINESS_GRP dependencies on PER_JOB_GROUPS

Line 418: from per_job_groups

414: * they are creating in this way, so we have to check and handle this in PA.
415: */
416: select job_group_id
417: into x_master_grp_id
418: from per_job_groups
419: where pa_cross_business_grp.IsCrossBGProfile = 'N'
420: and business_group_id = P_Business_group_Id
421: and master_flag = 'Y'
422: UNION ALL

Line 424: from per_job_groups

420: and business_group_id = P_Business_group_Id
421: and master_flag = 'Y'
422: UNION ALL
423: select job_group_id
424: from per_job_groups
425: where pa_cross_business_grp.IsCrossBGProfile = 'Y'
426: and master_flag = 'Y' ;
427:
428: pa_cross_business_grp.ErrorStage(

Line 744: FROM PER_JOB_GROUPS

740: BEGIN
741:
742: SELECT JOB_GROUP_ID
743: INTO JobGroup
744: FROM PER_JOB_GROUPS
745: WHERE BUSINESS_GROUP_ID = P_Business_Group_Id
746: AND INTERNAL_NAME LIKE 'HR_%';
747:
748: RETURN ( JobGroup );