APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on HZ_CUST_ACCOUNTS

Line 1194: CURSOR C1 IS SELECT rowid FROM hz_cust_accounts

1190: c_customer_id number(15);
1191:
1192: CURSOR C IS SELECT party_id FROM hz_parties
1193: WHERE party_id = X_party_id;
1194: CURSOR C1 IS SELECT rowid FROM hz_cust_accounts
1195: WHERE cust_account_id = X_customer_id;
1196: CURSOR C2 IS SELECT customer_id FROM igi_ra_customers
1197: WHERE customer_id = X_customer_id;
1198:

Line 1233: SELECT hz_cust_accounts_s.nextval INTO X_Customer_Number

1229:
1230: OPEN c_gen_cust_num;
1231: FETCH c_gen_cust_num INTO l_gen_cust_num;
1232: IF (l_gen_cust_num <> 'Y') THEN
1233: SELECT hz_cust_accounts_s.nextval INTO X_Customer_Number
1234: FROM dual;
1235: END IF;
1236: CLOSE c_gen_cust_num;
1237:

Line 1399: FROM hz_cust_accounts a,hz_parties p

1395: l_object_cust_version_number NUMBER;
1396:
1397: CURSOR c_all IS
1398: SELECT nvl(a.object_version_number,fnd_api.G_NULL_NUM),a.party_id,a.cust_account_id,nvl(p.object_version_number,fnd_api.G_NULL_NUM)
1399: FROM hz_cust_accounts a,hz_parties p
1400: WHERE a.party_id = p.party_id
1401: AND a.rowid = X_rowid;
1402:
1403: BEGIN

Line 1459: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p

1455: stp_type = X_stp_type,
1456: last_update_login = X_last_update_login,
1457: last_update_date = X_last_update_date,
1458: last_updated_by = X_last_updated_by
1459: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p
1460: where a.party_id = p.party_id and a.rowid = X_rowid); -- Bug 3902175
1461:
1462: IF (SQL%NOTFOUND) THEN
1463: Raise NO_DATA_FOUND;

Line 1492: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p -- Bug 3902175

1488:
1489: CURSOR C1 IS
1490: SELECT *
1491: FROM igi_ra_customers irc
1492: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p -- Bug 3902175
1493: where a.party_id = p.party_id and a.rowid = X_rowid)
1494: FOR UPDATE OF irc.customer_id NOWAIT;
1495:
1496: RecCust1 C1%ROWTYPE;