APPS.HR_SCL_FLEX dependencies on FND_COMMON_LOOKUPS

Line 192: -- a) Segment3 must exist as a lookup_code in the table FND_COMMON_LOOKUPS

188: -- {Start of Comments}
189: --
190: -- Description:
191: -- Validates the segment3 attribute for US legislation as follows :
192: -- a) Segment3 must exist as a lookup_code in the table FND_COMMON_LOOKUPS
193: -- for the lookup_type = 'YES_NO'
194: --
195: -- Pre-Conditions
196: -- None

Line 222: from FND_COMMON_LOOKUPS lu

218: l_business_group_id number;
219: --
220: cursor csr_chk_yes_no is
221: select null
222: from FND_COMMON_LOOKUPS lu
223: where lu.lookup_type = 'YES_NO'
224: and lu.lookup_code = p_segment3;
225: --
226: begin

Line 332: -- a) Segment5 must exist as a lookup_code in the table FND_COMMON_LOOKUPS

328: -- {Start of Comments}
329: --
330: -- Description:
331: -- Validates the segment5 attribute for US legislation as follows :
332: -- a) Segment5 must exist as a lookup_code in the table FND_COMMON_LOOKUPS
333: -- for the lookup_type = 'US_SHIFTS'
334: --
335: -- Pre-Conditions
336: -- None

Line 361: from FND_COMMON_LOOKUPS lu

357: l_proc varchar2(72) := g_package||'chk_us_segment5';
358: --
359: cursor csr_chk_shift is
360: select null
361: from FND_COMMON_LOOKUPS lu
362: where lu.lookup_type = 'US_SHIFTS'
363: and lu.lookup_code = p_segment5
364: and lu.application_id = 800;
365: --

Line 463: -- a) Segment7 must exist as a lookup_code in the table FND_COMMON_LOOKUPS

459: -- {Start of Comments}
460: --
461: -- Description:
462: -- Validates the segment7 attribute for US legislation as follows :
463: -- a) Segment7 must exist as a lookup_code in the table FND_COMMON_LOOKUPS
464: -- for the lookup_type = 'YES_NO'
465: --
466: -- Pre-Conditions
467: -- None

Line 493: from FND_COMMON_LOOKUPS lu

489: l_business_group_id number;
490: --
491: cursor csr_chk_yes_no is
492: select null
493: from FND_COMMON_LOOKUPS lu
494: where lu.lookup_type = 'YES_NO'
495: and lu.lookup_code = p_segment7;
496: --
497: begin