DBA Data[Home] [Help]

APPS.IGF_AP_LG_VER_IMP dependencies on HZ_PARTIES

Line 17: CURSOR c_fabase ( p_person_number hz_parties.party_number%TYPE ) IS

13: g_log_tab LogTab;
14:
15:
16: -- global cursor for fa base rec
17: CURSOR c_fabase ( p_person_number hz_parties.party_number%TYPE ) IS
18: SELECT fabase.*
19: FROM igf_ap_fa_base_rec fabase,
20: hz_parties hz
21: WHERE hz.party_id = fabase.person_id

Line 20: hz_parties hz

16: -- global cursor for fa base rec
17: CURSOR c_fabase ( p_person_number hz_parties.party_number%TYPE ) IS
18: SELECT fabase.*
19: FROM igf_ap_fa_base_rec fabase,
20: hz_parties hz
21: WHERE hz.party_id = fabase.person_id
22: AND hz.party_number = p_person_number
23: AND fabase.ci_cal_type = g_ci_cal_type
24: AND fabase.ci_sequence_number = g_ci_sequence_number ;