APPS.IGF_AP_ISIR_GEN_PKG dependencies on IGF_AP_PERSON_MATCH_ALL

Line 1907: CURSOR cur_get_person_match ( cp_si_id igf_ap_person_match_all.si_id%TYPE) IS

1903: || Who When What
1904: */
1905:
1906: -- Cursor to fetch apm_id from person match table of an isir interface record.
1907: CURSOR cur_get_person_match ( cp_si_id igf_ap_person_match_all.si_id%TYPE) IS
1908: SELECT ROWID row_id, apm_id
1909: FROM IGF_AP_PERSON_MATCH_ALL permatch
1910: WHERE permatch.si_id = cp_si_id;
1911:

Line 1909: FROM IGF_AP_PERSON_MATCH_ALL permatch

1905:
1906: -- Cursor to fetch apm_id from person match table of an isir interface record.
1907: CURSOR cur_get_person_match ( cp_si_id igf_ap_person_match_all.si_id%TYPE) IS
1908: SELECT ROWID row_id, apm_id
1909: FROM IGF_AP_PERSON_MATCH_ALL permatch
1910: WHERE permatch.si_id = cp_si_id;
1911:
1912: -- Cursor to fetch rowids of child records (match detail records) of person match record.
1913: CURSOR cur_get_match_detail ( cp_apm_id igf_ap_person_match_all.apm_id%TYPE) IS

Line 1913: CURSOR cur_get_match_detail ( cp_apm_id igf_ap_person_match_all.apm_id%TYPE) IS

1909: FROM IGF_AP_PERSON_MATCH_ALL permatch
1910: WHERE permatch.si_id = cp_si_id;
1911:
1912: -- Cursor to fetch rowids of child records (match detail records) of person match record.
1913: CURSOR cur_get_match_detail ( cp_apm_id igf_ap_person_match_all.apm_id%TYPE) IS
1914: SELECT ROWID row_id
1915: FROM IGF_AP_MATCH_DETAILS matchdtls
1916: WHERE matchdtls.apm_id = cp_apm_id;
1917: