DBA Data[Home] [Help]

APPS.GHR_LACS_REMARKS dependencies on FND_COMMON_LOOKUPS

Line 409: FROM fnd_common_lookups fcl

405: IF l_la_code1 IS NOT NULL THEN -- Update GHR_PA_REQUESTS with new LACs
406: l_location := 'Apply_894_Rules:Replacing Insertion Value';
407: SELECT description
408: INTO l_la_desc1
409: FROM fnd_common_lookups fcl
410: WHERE fcl.lookup_code = l_la_code1
411: AND fcl.application_id = 800
412: AND fcl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'
413: AND fcl.enabled_flag = 'Y'

Line 430: FROM fnd_common_lookups fcl

426: END IF;
427: IF l_la_code2 IS NOT NULL THEN
428: SELECT description
429: INTO l_la_desc2
430: FROM fnd_common_lookups fcl
431: WHERE fcl.lookup_code = l_la_code2
432: AND fcl.application_id = 800
433: AND fcl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'
434: AND fcl.enabled_flag = 'Y'

Line 598: FROM fnd_common_lookups fcl

594: l_location := 'Apply_895_Rules:Replacing Insertion Value';
595:
596: SELECT description
597: INTO l_la_desc1
598: FROM fnd_common_lookups fcl
599: WHERE fcl.lookup_code = l_la_code1
600: AND fcl.application_id = 800
601: AND fcl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'
602: AND fcl.enabled_flag = 'Y'