APPS.HR_WPM_UTIL dependencies on HR_GENERAL

Line 357: AND business_group_id = hr_general.get_business_group_id

353: SELECT information1 --- return from BG specific. If not defined then Global
354: FROM per_shared_types
355: WHERE lookup_type = 'READINESS_LEVEL'
356: AND system_type_cd = p_potential
357: AND business_group_id = hr_general.get_business_group_id
358: UNION ALL
359: SELECT information1
360: FROM per_shared_types
361: WHERE lookup_type = 'READINESS_LEVEL'

Line 372: AND business_group_id = hr_general.get_business_group_id

368: SELECT information1 --- return from BG specific. If not defined then Global
369: FROM per_shared_types
370: WHERE lookup_type = 'PER_SUCC_PLAN_POTENTIAL'
371: AND system_type_cd = p_potential
372: AND business_group_id = hr_general.get_business_group_id
373: UNION ALL
374: SELECT information1
375: FROM per_shared_types
376: WHERE lookup_type = 'PER_SUCC_PLAN_POTENTIAL'

Line 463: NVL2 (business_group_id, hr_general.get_business_group_id,

459: FROM per_shared_types
460: WHERE lookup_type = 'PERFORMANCE_RATING'
461: AND system_type_cd = p_perf
462: AND NVL (business_group_id, -1) =
463: NVL2 (business_group_id, hr_general.get_business_group_id,
464: -1)
465: UNION ALL
466: SELECT information1
467: FROM per_shared_types

Line 535: AND business_group_id = hr_general.get_business_group_id

531: SELECT information1 --- return from BG specific. If not defined then Global
532: FROM per_shared_types
533: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
534: AND system_type_cd = p_retention
535: AND business_group_id = hr_general.get_business_group_id
536: UNION ALL
537: SELECT information1
538: FROM per_shared_types
539: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'

Line 550: AND business_group_id = hr_general.get_business_group_id

546: SELECT information1 --- return from BG specific. If not defined then Global
547: FROM per_shared_types
548: WHERE lookup_type = 'PER_SUCC_PLAN_RISK_LEVEL'
549: AND system_type_cd = p_retention
550: AND business_group_id = hr_general.get_business_group_id
551: UNION ALL
552: SELECT information1
553: FROM per_shared_types
554: WHERE lookup_type = 'PER_SUCC_PLAN_RISK_LEVEL'

Line 665: AND business_group_id = hr_general.get_business_group_id

661: SELECT information1 --- return from BG specific. If not defined then Global
662: FROM per_shared_types
663: WHERE lookup_type = 'READINESS_LEVEL'
664: AND system_type_cd = p_potential
665: AND business_group_id = hr_general.get_business_group_id
666: UNION ALL
667: SELECT information1
668: FROM per_shared_types
669: WHERE lookup_type = 'READINESS_LEVEL'

Line 731: AND business_group_id = hr_general.get_business_group_id

727: SELECT information1 --- return from BG specific. If not defined then Global
728: FROM per_shared_types
729: WHERE lookup_type = 'PER_SP_IMPACT_OF_LOSS'
730: AND system_type_cd = p_iol
731: AND business_group_id = hr_general.get_business_group_id
732: UNION ALL
733: SELECT information1
734: FROM per_shared_types
735: WHERE lookup_type = 'PER_SP_IMPACT_OF_LOSS'

Line 783: NVL2 (business_group_id, hr_general.get_business_group_id,

779: FROM per_shared_types
780: WHERE lookup_type = 'PERFORMANCE_RATING'
781: AND system_type_cd = p_perf
782: AND NVL (business_group_id, -1) =
783: NVL2 (business_group_id, hr_general.get_business_group_id,
784: -1)
785: UNION ALL
786: SELECT information1
787: FROM per_shared_types

Line 833: AND business_group_id = hr_general.get_business_group_id

829: SELECT information1 --- return from BG specific. If not defined then Global
830: FROM per_shared_types
831: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
832: AND system_type_cd = p_retention
833: AND business_group_id = hr_general.get_business_group_id
834: UNION ALL
835: SELECT information1
836: FROM per_shared_types
837: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'

Line 892: AND business_group_id = hr_general.get_business_group_id

888: SELECT information1 --- return from BG specific. If not defined then Global
889: FROM per_shared_types
890: WHERE lookup_type = 'PER_SP_IMPACT_OF_LOSS'
891: AND system_type_cd = p_iol
892: AND business_group_id = hr_general.get_business_group_id
893: UNION ALL
894: SELECT information1
895: FROM per_shared_types
896: WHERE lookup_type = 'PER_SP_IMPACT_OF_LOSS'

Line 906: AND business_group_id = hr_general.get_business_group_id

902: SELECT information1 --- return from BG specific. If not defined then Global
903: FROM per_shared_types
904: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
905: AND system_type_cd = p_retention
906: AND business_group_id = hr_general.get_business_group_id
907: UNION ALL
908: SELECT information1
909: FROM per_shared_types
910: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'