DBA Data[Home] [Help]

APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_AP_MATCHING_PROCESS_PKG

Line 4851: AND igf_ap_matching_process_pkg.remove_spl_chr(ppf.national_identifier) = cp_v_ssn;

4847: AND pbg.business_group_id = ppf.business_group_id
4848: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
4849: AND ppf.party_id = hz.party_id
4850: AND hp.effective_end_date IS NULL
4851: AND igf_ap_matching_process_pkg.remove_spl_chr(ppf.national_identifier) = cp_v_ssn;
4852:
4853: TYPE tab_firstname_typ IS TABLE OF hz_parties.person_first_name%TYPE;
4854: TYPE tab_lastname_typ IS TABLE OF hz_parties.person_last_name%TYPE;
4855: TYPE tab_prsn_ssn_typ IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;

Line 5140: x_api_person_id => igf_ap_matching_process_pkg.format_ssn(l_v_ssn)/*,

5136: x_attribute18 => NULL,
5137: x_attribute19 => NULL,
5138: x_attribute20 => NULL,
5139: x_person_id_type => l_v_person_id_type,
5140: x_api_person_id => igf_ap_matching_process_pkg.format_ssn(l_v_ssn)/*,
5141: x_attribute21 => NULL,
5142: x_attribute22 => NULL,
5143: x_attribute23 => NULL,
5144: x_attribute24 => NULL*/