DBA Data[Home] [Help]

APPS.INVCIINT dependencies on AR_LOOKUPS

Line 1214: FROM AR_LOOKUPS ARL

1210: IF (P_Customer_Category_Code IS NOT NULL) THEN
1211:
1212: SELECT ARL.Lookup_Code, ARL.Enabled_Flag, ARL.Start_Date_Active, ARL.End_Date_Active
1213: INTO Temp_Lookup_Code, Temp_Enabled_Flag, Temp_Start_Date_Active, Temp_End_Date_Active
1214: FROM AR_LOOKUPS ARL
1215: WHERE ARL.Lookup_Code = P_Customer_Category_Code
1216: AND ARL.Lookup_Type = 'ADDRESS_CATEGORY'
1217: AND rownum = 1;
1218:

Line 1245: FROM AR_LOOKUPS ARL

1241: ELSIF ((P_Customer_Category_Code IS NULL) AND (P_Customer_Category IS NOT NULL)) THEN
1242:
1243: SELECT ARL.Lookup_Code, ARL.Enabled_Flag, ARL.Start_Date_Active, ARL.End_Date_Active
1244: INTO Temp_Lookup_Code, Temp_Enabled_Flag, Temp_Start_Date_Active, Temp_End_Date_Active
1245: FROM AR_LOOKUPS ARL
1246: WHERE UPPER(ARL.Meaning) = UPPER(P_Customer_Category)
1247: AND ARL.Lookup_Type = 'ADDRESS_CATEGORY'
1248: AND rownum = 1;
1249: