APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on HZ_PARTIES

Line 2897: PROCEDURE get_party_id(p_c_person_number IN hz_parties.party_number%TYPE,

2893: END IF;
2894:
2895: END validate_org_unit_cd;
2896:
2897: PROCEDURE get_party_id(p_c_person_number IN hz_parties.party_number%TYPE,
2898: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE) AS
2899: /***********************************************************************************************
2900: Created By : smvk
2901: Date Created By: 26-DEC-2002

Line 2898: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE) AS

2894:
2895: END validate_org_unit_cd;
2896:
2897: PROCEDURE get_party_id(p_c_person_number IN hz_parties.party_number%TYPE,
2898: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE) AS
2899: /***********************************************************************************************
2900: Created By : smvk
2901: Date Created By: 26-DEC-2002
2902: Purpose : Gets the party identifier for the given party number for Active and Inactive records.

Line 2908: CURSOR c_party_id (cp_c_party_number IN hz_parties.party_number%type) IS

2904: Known limitations,enhancements,remarks:
2905: Change History (in reverse chronological order)
2906: Who When What
2907: ********************************************************************************************** */
2908: CURSOR c_party_id (cp_c_party_number IN hz_parties.party_number%type) IS
2909: SELECT hz.party_id
2910: FROM hz_parties hz
2911: WHERE hz.party_number = cp_c_party_number
2912: AND hz.status in ('A','I');

Line 2910: FROM hz_parties hz

2906: Who When What
2907: ********************************************************************************************** */
2908: CURSOR c_party_id (cp_c_party_number IN hz_parties.party_number%type) IS
2909: SELECT hz.party_id
2910: FROM hz_parties hz
2911: WHERE hz.party_number = cp_c_party_number
2912: AND hz.status in ('A','I');
2913:
2914: BEGIN

Line 3926: FROM IGS_PE_PERSON_TYPES PT,IGS_PE_TYP_INSTANCES_ALL PTI,HZ_PARTIES HZ

3922: ***********************************************************************************************/
3923:
3924: CURSOR C IS
3925: SELECT 'X'
3926: FROM IGS_PE_PERSON_TYPES PT,IGS_PE_TYP_INSTANCES_ALL PTI,HZ_PARTIES HZ
3927: WHERE HZ.PARTY_ID = PTI.PERSON_ID
3928: AND HZ.PARTY_ID = p_person_id
3929: AND PTI.PERSON_TYPE_CODE = PT.PERSON_TYPE_CODE
3930: AND PT.SYSTEM_TYPE IN ('STAFF','FACULTY')

Line 3935: FROM PER_PERSON_TYPE_USAGES_F USG,PER_PEOPLE_F PEO,IGS_PE_PER_TYPE_MAP MAP,HZ_PARTIES HZ

3931: AND TRUNC(SYSDATE) BETWEEN TRUNC(PTI.START_DATE) AND TRUNC(NVL(PTI.END_DATE,SYSDATE))
3932: AND HZ.STATUS = 'A'
3933: UNION
3934: SELECT 'X'
3935: FROM PER_PERSON_TYPE_USAGES_F USG,PER_PEOPLE_F PEO,IGS_PE_PER_TYPE_MAP MAP,HZ_PARTIES HZ
3936: WHERE HZ.PARTY_ID = peo.party_id
3937: AND USG.PERSON_ID = PEO.PERSON_ID
3938: AND HZ.PARTY_ID = p_person_id
3939: AND USG.PERSON_TYPE_ID = MAP.PER_PERSON_TYPE_ID AND TRUNC(SYSDATE) BETWEEN