APPS.HR_PSF_BUS dependencies on FND_COMMON_LOOKUPS

Line 1552: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'FREQUENCY'. (I,U)

1548: -- or if WORKING_HOURS is null and FREQUENCY is not null an error
1549: -- is raised
1550: --
1551: -- Validate the FREQUENCY value against the table
1552: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'FREQUENCY'. (I,U)
1553: --
1554: -- Validate that if the value for WORKING_HOURS is NOT NULL,
1555: -- that the FREQUENCY value is valid for the WORKING_HOURS value.
1556: --

Line 1598: from fnd_common_lookups

1594: l_api_updating boolean;
1595: --
1596: cursor csr_valid_freq is
1597: select 'x'
1598: from fnd_common_lookups
1599: where lookup_type = 'FREQUENCY'
1600: and lookup_code = p_frequency
1601: and enabled_flag = 'Y'
1602: and p_effective_date between nvl(start_date_active,p_effective_date)

Line 1641: -- Check for valid frequency against fnd_common_lookups

1637: hr_utility.set_message(800,'PER_52981_POS_WORK_FREQ_NULL');
1638: hr_utility.raise_error;
1639: end if;
1640: --
1641: -- Check for valid frequency against fnd_common_lookups
1642: --
1643: if g_debug then
1644: hr_utility.set_location(l_proc, 6);
1645: end if;

Line 2738: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'QUALIFYING_UNITS'.

2734: -- is not null or if PROBATION_PERIOD is not null and PROBATION_PERIOS_UNITS
2735: -- is null then an error is raised
2736: --
2737: -- Validate the value for PROBATION_PERIOD_UNITS against the table
2738: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'QUALIFYING_UNITS'.
2739: --
2740: -- Pre-conditions:
2741: -- None
2742: --

Line 2776: from fnd_common_lookups

2772: l_exists varchar2(1);
2773: --
2774: cursor csr_valid_unit is
2775: select 'x'
2776: from fnd_common_lookups
2777: where lookup_type = 'QUALIFYING_UNITS'
2778: and lookup_code = p_probation_period_unit_cd;
2779: --
2780: begin

Line 2817: -- Validate probation_period_unit_cd against fnd_common_lookups

2813: hr_utility.set_message(800,'HR_51365_POS_PROB_UNITS_REQ');
2814: hr_utility.raise_error;
2815: else
2816: --
2817: -- Validate probation_period_unit_cd against fnd_common_lookups
2818: --
2819: if g_debug then
2820: hr_utility.set_location(l_proc, 3);
2821: end if;