DBA Data[Home] [Help]

APPS.RLM_CORE_SV dependencies on HZ_PARTIES

Line 1303: FROM HZ_PARTIES PARTY,

1299:
1300: -- Following cursor is changed as per TCA obsolescence project.
1301: CURSOR c IS
1302: SELECT PARTY.PARTY_NAME customer_name
1303: FROM HZ_PARTIES PARTY,
1304: HZ_CUST_ACCOUNTS CUST_ACCT
1305: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1306: AND cust_acct.cust_account_id = x_customer_id;
1307:

Line 1309: v_customer_name hz_parties.party_name%TYPE;

1305: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1306: AND cust_acct.cust_account_id = x_customer_id;
1307:
1308: -- Following parameter definition is changed as per TCA obsolescence project.
1309: v_customer_name hz_parties.party_name%TYPE;
1310: --
1311: BEGIN
1312: --
1313: dpush('get_customer_name');