APPS.AHL_APPROVALS_PVT dependencies on FND_LOOKUPS

Line 605: FROM FND_LOOKUPS

601: -- Reema :
602: -- Added cursor for Application Usage Code
603: CURSOR c_appl_usg IS
604: SELECT LOOKUP_CODE
605: FROM FND_LOOKUPS
606: WHERE MEANING = l_Approval_Rules_rec.APPLICATION_USG
607: AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
608:
609: BEGIN

Line 867: FROM FND_LOOKUPS

863: WHERE Approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
864:
865: CURSOR c_appl_usg IS
866: SELECT LOOKUP_CODE
867: FROM FND_LOOKUPS
868: WHERE MEANING = l_Approval_Rules_rec.APPLICATION_USG
869: AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
870:
871: BEGIN

Line 1429: SELECT 1 FROM FND_LOOKUPS

1425: IS
1426: l_count NUMBER;
1427:
1428: CURSOR chk_appl_usg_code IS
1429: SELECT 1 FROM FND_LOOKUPS
1430: WHERE meaning = p_Approval_Rules_rec.Application_Usg
1431: AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
1432: BEGIN
1433: OPEN chk_appl_usg_code;

Line 2219: -- from fnd_lookups

2215: END IF;
2216:
2217: -- Reema:
2218: -- Retrieve the application usage code
2219: -- from fnd_lookups
2220: /* OPEN c_appl_usg;
2221: FETCH c_appl_usg INTO l_application_usg_code;
2222: IF c_appl_usg%NOTFOUND THEN
2223: l_application_usg_code := NULL;