APPS.GHR_LACS_REMARKS dependencies on FND_COMMON_LOOKUPS

Line 422: FROM fnd_common_lookups fcl

418: IF l_la_code1 IS NOT NULL THEN -- Update GHR_PA_REQUESTS with new LACs
419: l_location := 'Apply_894_Rules:Replacing Insertion Value';
420: SELECT description
421: INTO l_la_desc1
422: FROM fnd_common_lookups fcl
423: WHERE fcl.lookup_code = l_la_code1
424: AND fcl.application_id = 800
425: AND fcl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'
426: AND fcl.enabled_flag = 'Y'

Line 443: FROM fnd_common_lookups fcl

439: END IF;
440: IF l_la_code2 IS NOT NULL THEN
441: SELECT description
442: INTO l_la_desc2
443: FROM fnd_common_lookups fcl
444: WHERE fcl.lookup_code = l_la_code2
445: AND fcl.application_id = 800
446: AND fcl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'
447: AND fcl.enabled_flag = 'Y'

Line 613: FROM fnd_common_lookups fcl

609: l_location := 'Apply_895_Rules:Replacing Insertion Value';
610:
611: SELECT description
612: INTO l_la_desc1
613: FROM fnd_common_lookups fcl
614: WHERE fcl.lookup_code = l_la_code1
615: AND fcl.application_id = 800
616: AND fcl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'
617: AND fcl.enabled_flag = 'Y'