APPS.HR_WPM_UTIL dependencies on FND_PROFILE

Line 380: IF NVL (fnd_profile.VALUE ('HR_SUCCESSION_MGMT_LICENSED'), 'N') = 'Y'

376: WHERE lookup_type = 'PER_SUCC_PLAN_POTENTIAL'
377: AND system_type_cd = p_potential
378: AND business_group_id IS NULL;
379: BEGIN
380: IF NVL (fnd_profile.VALUE ('HR_SUCCESSION_MGMT_LICENSED'), 'N') = 'Y'
381: THEN
382: OPEN csr_pot_new_eit (p_person_id, p_effective_date);
383:
384: FETCH csr_pot_new_eit

Line 558: IF NVL (fnd_profile.VALUE ('HR_SUCCESSION_MGMT_LICENSED'), 'N') = 'Y'

554: WHERE lookup_type = 'PER_SUCC_PLAN_RISK_LEVEL'
555: AND system_type_cd = p_retention
556: AND business_group_id IS NULL;
557: BEGIN
558: IF NVL (fnd_profile.VALUE ('HR_SUCCESSION_MGMT_LICENSED'), 'N') = 'Y'
559: THEN
560: OPEN csr_ret_new_eit (p_person_id, p_effective_date);
561:
562: FETCH csr_ret_new_eit

Line 1012: ,decode (fnd_profile.value ('PER_SP_SHOW_TERMINATED')

1008: WHERE EXISTS (
1009: SELECT NULL
1010: FROM per_person_types typ, per_person_type_usages_f ptu
1011: WHERE typ.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'APL'
1012: ,decode (fnd_profile.value ('PER_SP_SHOW_TERMINATED')
1013: ,'Y'
1014: ,'EX_EMP')
1015: ,decode (fnd_profile.value ('PER_SP_SHOW_TERMINATED')
1016: ,'Y'

Line 1015: ,decode (fnd_profile.value ('PER_SP_SHOW_TERMINATED')

1011: WHERE typ.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'APL'
1012: ,decode (fnd_profile.value ('PER_SP_SHOW_TERMINATED')
1013: ,'Y'
1014: ,'EX_EMP')
1015: ,decode (fnd_profile.value ('PER_SP_SHOW_TERMINATED')
1016: ,'Y'
1017: ,'EX_CWK'))
1018: AND typ.person_type_id = ptu.person_type_id
1019: AND TRUNC (SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date