APPS.IGS_CO_PROCESS dependencies on HZ_PARTIES

Line 229: fnd_dsql.add_text(' hz_parties WHERE party_id = ');

225: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
226: fnd_dsql.add_bind(p_person_id);
227: END IF;
228: ELSE
229: fnd_dsql.add_text(' hz_parties WHERE party_id = ');
230: fnd_dsql.add_bind(p_person_id);
231: END IF;
232:
233: ELSIF p_select_type = 'L' THEN

Line 900: CURSOR c_org_unit_addr(cp_party_id hz_parties.party_id%TYPE) IS

896: ipl.sequence_number = p_appl_sequence_number AND
897: ipl.panel_code = p_panel_code ;
898:
899: -- Cursor to get address info of an Orgn Unit
900: CURSOR c_org_unit_addr(cp_party_id hz_parties.party_id%TYPE) IS
901: SELECT P.ADDRESS1, P.ADDRESS2, P.ADDRESS3, P.ADDRESS4, P.POSTAL_CODE,
902: P.PARTY_NAME, TERR.TERRITORY_SHORT_NAME COUNTRY, P.CITY,
903: P.STATE, P.PROVINCE, P.COUNTY
904: FROM

Line 905: HZ_PARTIES P, FND_TERRITORIES_VL TERR

901: SELECT P.ADDRESS1, P.ADDRESS2, P.ADDRESS3, P.ADDRESS4, P.POSTAL_CODE,
902: P.PARTY_NAME, TERR.TERRITORY_SHORT_NAME COUNTRY, P.CITY,
903: P.STATE, P.PROVINCE, P.COUNTY
904: FROM
905: HZ_PARTIES P, FND_TERRITORIES_VL TERR
906: WHERE
907: P.PARTY_ID = cp_party_id AND
908: TERR.TERRITORY_CODE = P.COUNTRY ;
909:

Line 1788: p_view_name := ' hz_parties';

1784: Bayadav 24-MAY-2002 Included two system letter codes 'ENADHOC', 'SFADHOC' for adhoc letters as a part of bug 2376434
1785: ***************************************************************/
1786: BEGIN
1787: IF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
1788: p_view_name := ' hz_parties';
1789: ELSIF p_sys_ltr_code = 'ADMISTM' THEN
1790: p_view_name := ' igs_ad_missing_items_letter_v';
1791: p_where_clause := ' s_adm_outcome_status <> ''CANCELLED''';
1792: ELSIF p_sys_ltr_code = 'ADACKMT' THEN

Line 1888: l_parameter_7 hz_parties.party_id%TYPE;

1884: l_acad_cal_type VARCHAR(15); --igs_ad_missing_items_letter_v.acad_cal_type%TYPE;
1885: l_acad_ci_sequence_number igs_ad_missing_items_letter_v.acad_ci_sequence_number%TYPE;
1886: l_adm_cal_type VARCHAR(15); --igs_ad_ps_appl_inst.adm_cal_type%TYPE;
1887: l_adm_ci_sequence_number igs_ad_ps_appl_inst.adm_ci_sequence_number%TYPE;
1888: l_parameter_7 hz_parties.party_id%TYPE;
1889: l_parameter_8 igs_co_interac_hist.adm_application_number%TYPE;
1890: l_parameter_9 igs_co_interac_hist.nominated_course_cd%TYPE;
1891: l_parameter_10 igs_co_interac_hist.ci_sequence_number%TYPE;
1892: