APPS.IGS_PS_USEC_SCHEDULE dependencies on HZ_PARTIES

Line 902: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_pe_person_v with hz_parties for cursor instrs

898:
899: Change History
900:
901: Who When What
902: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_pe_person_v with hz_parties for cursor instrs
903: ***************************************************************/
904: l_int_occurs_id igs_ps_sch_int_all.int_occurs_id%TYPE;
905: -- Get the reference code and reference code type
906: CURSOR ref_cd( l_usec_id igs_ps_usec_occurs.unit_section_occurrence_id%TYPE) IS

Line 924: HZ_PARTIES B

920: B.PERSON_FIRST_NAME given_names,
921: B.PERSON_MIDDLE_NAME middle_name,
922: B.party_name person_name
923: FROM igs_ps_uso_instrctrs_v A,
924: HZ_PARTIES B
925: WHERE A.person_number = B.party_number AND
926: A.unit_section_occurrence_id = l_usec_id;
927:
928: -- Get the Facilities associated with the usec_id