APPS.INVCIINT dependencies on HZ_CUST_ACCOUNTS

Line 943: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

939: WHERE RAC.Customer_Id = P_Customer_Id;
940: **/
941: SELECT CUST_ACCT.CUST_ACCOUNT_ID, CUST_ACCT.STATUS
942: INTO Temp_Customer_Id, Temp_Status
943: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
944: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
945: AND CUST_ACCT.CUST_ACCOUNT_ID = P_Customer_Id;
946:
947: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN

Line 971: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

967: WHERE RAC.Customer_Number = P_Customer_Number;
968: **/
969: SELECT CUST_ACCT.CUST_ACCOUNT_ID, CUST_ACCT.STATUS
970: INTO Temp_Customer_Id, Temp_Status
971: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
972: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
973: AND CUST_ACCT.ACCOUNT_NUMBER = P_Customer_Number;
974:
975: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN

Line 999: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

995: WHERE RAC.Customer_Name = P_Customer_Name;
996: **/
997: SELECT CUST_ACCT.CUST_ACCOUNT_ID, CUST_ACCT.STATUS
998: INTO Temp_Customer_Id, Temp_Status
999: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
1000: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1001: AND PARTY.PARTY_NAME like P_Customer_Name || '%';
1002:
1003: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN