APPS.ZX_RATES_PKG dependencies on FND_LOOKUPS

Line 1062: -- Effective From and To date. So get the Max(Start Date) and Min(End Date) from fnd_lookups

1058: L_EFFECTIVE_FROM := X_EFFECTIVE_FROM;
1059: L_EFFECTIVE_TO := X_EFFECTIVE_TO;
1060:
1061: -- Bug # 5559151. If this procedure is called from Tax Rules/Condition Set UI then we are not passing the
1062: -- Effective From and To date. So get the Max(Start Date) and Min(End Date) from fnd_lookups
1063: IF L_EFFECTIVE_FROM IS NULL THEN
1064:
1065: SELECT MAX(START_DATE_ACTIVE) INTO L_EFFECTIVE_FROM
1066: FROM FND_LOOKUPS

Line 1066: FROM FND_LOOKUPS

1062: -- Effective From and To date. So get the Max(Start Date) and Min(End Date) from fnd_lookups
1063: IF L_EFFECTIVE_FROM IS NULL THEN
1064:
1065: SELECT MAX(START_DATE_ACTIVE) INTO L_EFFECTIVE_FROM
1066: FROM FND_LOOKUPS
1067: WHERE LOOKUP_TYPE IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS' , 'ZX_OUTPUT_CLASSIFICATIONS')
1068: AND ENABLED_FLAG = 'Y'
1069: AND SYSDATE BETWEEN START_DATE_ACTIVE
1070: AND NVL(END_DATE_ACTIVE,SYSDATE)

Line 1076: FROM FND_LOOKUPS

1072:
1073: BEGIN
1074:
1075: SELECT END_DATE_ACTIVE INTO L_EFFECTIVE_TO
1076: FROM FND_LOOKUPS
1077: WHERE LOOKUP_TYPE IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS' , 'ZX_OUTPUT_CLASSIFICATIONS')
1078: AND ENABLED_FLAG = 'Y'
1079: AND SYSDATE BETWEEN START_DATE_ACTIVE
1080: AND NVL(END_DATE_ACTIVE,SYSDATE)

Line 1089: FROM FND_LOOKUPS

1085: EXCEPTION
1086:
1087: WHEN NO_DATA_FOUND THEN
1088: SELECT MAX(END_DATE_ACTIVE) INTO L_EFFECTIVE_TO
1089: FROM FND_LOOKUPS
1090: WHERE LOOKUP_TYPE IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS' , 'ZX_OUTPUT_CLASSIFICATIONS')
1091: AND ENABLED_FLAG = 'Y'
1092: AND SYSDATE BETWEEN START_DATE_ACTIVE
1093: AND NVL(END_DATE_ACTIVE,SYSDATE)