APPS.IGS_AD_IMP_002 dependencies on IGS_PE_PERSON_ADDR_V

Line 2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,

2574: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2575: l_location_ovn hz_locations.object_version_number%TYPE;
2576:
2577:
2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,
2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS
2580: SELECT *
2581: FROM IGS_PE_PERSON_ADDR_V
2582: WHERE location_id = cp_location_id AND

Line 2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS

2575: l_location_ovn hz_locations.object_version_number%TYPE;
2576:
2577:
2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,
2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS
2580: SELECT *
2581: FROM IGS_PE_PERSON_ADDR_V
2582: WHERE location_id = cp_location_id AND
2583: party_site_id = cp_party_site_id;

Line 2581: FROM IGS_PE_PERSON_ADDR_V

2577:
2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,
2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS
2580: SELECT *
2581: FROM IGS_PE_PERSON_ADDR_V
2582: WHERE location_id = cp_location_id AND
2583: party_site_id = cp_party_site_id;
2584:
2585: null_hand_addr_rec null_hand_addr_cur%ROWTYPE;