APPS.IGS_FI_PRC_APPL dependencies on HZ_PARTIES

Line 509: CURSOR cur_person_id(cp_person_id hz_parties.party_id%TYPE)

505: WHERE group_id = cp_person_grp
506: ORDER BY 1;
507:
508: -- cursor for getting the person_id when person id is passed
509: CURSOR cur_person_id(cp_person_id hz_parties.party_id%TYPE)
510: IS
511: SELECT party_id
512: FROM hz_parties
513: WHERE party_id = cp_person_id

Line 512: FROM hz_parties

508: -- cursor for getting the person_id when person id is passed
509: CURSOR cur_person_id(cp_person_id hz_parties.party_id%TYPE)
510: IS
511: SELECT party_id
512: FROM hz_parties
513: WHERE party_id = cp_person_id
514: ORDER BY 1;
515:
516: -- cursor for getting the person_id when neither of person id or

Line 650: FROM hz_parties p, igs_pe_hz_parties pd

646: IS
647: SELECT pd.fund_authorization, p.party_number
648: --bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
649: --bug:5018036, replaced igs_fi_person_v by base tables
650: FROM hz_parties p, igs_pe_hz_parties pd
651: WHERE p.party_id = cp_person_id
652: AND p.party_id = pd.party_id;
653:
654: --added by vvutukur

Line 661: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;

657: SELECT credit_type_name
658: FROM igs_fi_cr_types
659: WHERE credit_type_id = cp_credit_type_id;
660:
661: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;
662: v_tab_party_rec tab_party_rec ;
663: l_person_id hz_parties.party_id%TYPE;
664:
665: l_person_number igs_fi_parties_v.person_number%TYPE;

Line 663: l_person_id hz_parties.party_id%TYPE;

659: WHERE credit_type_id = cp_credit_type_id;
660:
661: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;
662: v_tab_party_rec tab_party_rec ;
663: l_person_id hz_parties.party_id%TYPE;
664:
665: l_person_number igs_fi_parties_v.person_number%TYPE;
666: l_credit_type_name igs_fi_cr_types.credit_type_name%TYPE;
667: