DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on HZ_CUST_ACCOUNTS

Line 1203: FROM hz_cust_accounts

1199: IS
1200: CURSOR c_cust_account_id
1201: IS
1202: SELECT cust_account_id
1203: FROM hz_cust_accounts
1204: WHERE cust_account_id = p_cust_account_id;
1205:
1206: CURSOR c_cust_account_number
1207: IS

Line 1209: FROM hz_cust_accounts

1205:
1206: CURSOR c_cust_account_number
1207: IS
1208: SELECT cust_account_id
1209: FROM hz_cust_accounts
1210: WHERE account_number = p_cust_account_number;
1211: BEGIN
1212: x_return_status := fnd_api.g_ret_sts_success;
1213:

Line 3543: FROM hz_cust_accounts

3539: CURSOR c_party_acct(b_acct_id number,
3540: b_party_id number)
3541: IS
3542: SELECT 'found'
3543: FROM hz_cust_accounts
3544: WHERE cust_account_id = b_acct_id
3545: AND party_id = b_party_id;
3546:
3547: x varchar2(10);