APPS.IGS_FI_PRC_LOCKBOX dependencies on HZ_PARTIES

Line 1910: p_v_party_number hz_parties.party_number%TYPE,

1906: END IF;
1907: END populate_lb_receipts;
1908:
1909: PROCEDURE val_charge_number_for_app(p_v_charge_code igs_fi_inv_int.invoice_number%TYPE,
1910: p_v_party_number hz_parties.party_number%TYPE,
1911: p_n_party_id pls_integer,
1912: p_v_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,
1913: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
1914: p_v_message_name OUT NOCOPY VARCHAR2) AS

Line 2387: -- In this cursor, HZ_PARTIES has been directly used to improve performance

2383: invocation fails
2384: ***************************************************************** */
2385: l_b_val_err BOOLEAN;
2386:
2387: -- In this cursor, HZ_PARTIES has been directly used to improve performance
2388: CURSOR cur_party(cp_party_number hz_parties.party_number%TYPE) IS
2389: SELECT party_id person_id
2390: FROM hz_parties
2391: WHERE party_number = cp_party_number;

Line 2388: CURSOR cur_party(cp_party_number hz_parties.party_number%TYPE) IS

2384: ***************************************************************** */
2385: l_b_val_err BOOLEAN;
2386:
2387: -- In this cursor, HZ_PARTIES has been directly used to improve performance
2388: CURSOR cur_party(cp_party_number hz_parties.party_number%TYPE) IS
2389: SELECT party_id person_id
2390: FROM hz_parties
2391: WHERE party_number = cp_party_number;
2392:

Line 2390: FROM hz_parties

2386:
2387: -- In this cursor, HZ_PARTIES has been directly used to improve performance
2388: CURSOR cur_party(cp_party_number hz_parties.party_number%TYPE) IS
2389: SELECT party_id person_id
2390: FROM hz_parties
2391: WHERE party_number = cp_party_number;
2392:
2393: CURSOR cur_lb_crt(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE) IS
2394: SELECT default_credit_type_id