DBA Data[Home] [Help]

APPS.INVCIINT dependencies on AR_LOOKUPS

Line 1215: FROM AR_LOOKUPS ARL

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

Line 1246: FROM AR_LOOKUPS ARL

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