eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_007 dependencies on IGS_PE_PERSON

Line 206: FROM IGS_PE_PERSON_BASE_V

202: ) AS
203:
204: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
205: SELECT Birth_date
206: FROM IGS_PE_PERSON_BASE_V
207: WHERE person_id= p_person_id;
208:
209:
210: l_var VARCHAR2(1);

Line 705: FROM igs_pe_person_base_v

701: || (reverse chronological order - newest change first)
702: */
703: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
704: SELECT birth_date
705: FROM igs_pe_person_base_v
706: WHERE person_id = p_person_id;
707:
708: l_birth_date igs_ad_interface.birth_dt%TYPE;
709: l_rec VARCHAR2(1);

Line 1444: FROM igs_pe_person_base_v

1440: PROCEDURE Validate_health_Ins(hlth_ins_rec IN HLTH_INS%ROWTYPE, l_check OUT NOCOPY VARCHAR2) AS
1441:
1442: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
1443: SELECT birth_date
1444: FROM igs_pe_person_base_v
1445: WHERE person_id= p_person_id;
1446:
1447: l_var VARCHAR2(1);
1448: l_birth_dt IGS_AD_INTERFACE.BIRTH_DT%TYPE;

Line 1959: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS

1955: */
1956: l_error_code VARCHAR2(30);
1957: l_exists VARCHAR2(1);
1958:
1959: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1960: SELECT format_mask, region_ind
1961: FROM igs_pe_person_id_typ
1962: WHERE person_id_type = cp_person_id_type
1963: AND closed_ind = 'N';

Line 1961: FROM igs_pe_person_id_typ

1957: l_exists VARCHAR2(1);
1958:
1959: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1960: SELECT format_mask, region_ind
1961: FROM igs_pe_person_id_typ
1962: WHERE person_id_type = cp_person_id_type
1963: AND closed_ind = 'N';
1964:
1965: CURSOR region_cd_cur(cp_geography_type hz_geographies.geography_type%TYPE, cp_geography_cd hz_geographies.geography_code%TYPE, cp_country_cd hz_geographies.country_code%TYPE) IS

Line 2667: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

2663: SELECT territory_short_name
2664: FROM fnd_territories_vl
2665: WHERE territory_code = cp_territory_code;
2666:
2667: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2668: SELECT birth_date FROM
2669: igs_pe_person_base_v WHERE
2670: person_id = cp_person_id;
2671:

Line 2669: igs_pe_person_base_v WHERE

2665: WHERE territory_code = cp_territory_code;
2666:
2667: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2668: SELECT birth_date FROM
2669: igs_pe_person_base_v WHERE
2670: person_id = cp_person_id;
2671:
2672: CURSOR date_overlap(PCZ_REC c_pcz%ROWTYPE) IS
2673: SELECT count(1) FROM HZ_CITIZENSHIP

Line 2684: l_birth_dt IGS_PE_PERSON.BIRTH_DT%TYPE;

2680: OR
2681: ( TRUNC(PCZ_REC.date_recognized) < TRUNC(date_recognized) AND
2682: NVL(TRUNC(end_date),IGS_GE_DATE.igsdate('9999/01/01'))< NVL(TRUNC(PCZ_REC.end_date),IGS_GE_DATE.igsdate('9999/01/01')) ) );
2683:
2684: l_birth_dt IGS_PE_PERSON.BIRTH_DT%TYPE;
2685: valid_country_rec c_valid_country%ROWTYPE;
2686: l_count NUMBER(3);
2687: l_last_update DATE;
2688: l_error VARCHAR2(30);

Line 2923: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

2919: WHERE party_id = pcz_rec.person_id
2920: AND country_code =pcz_rec.country_code
2921: AND date_recognized = pcz_rec.date_recognized;
2922:
2923: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2924: SELECT birth_date
2925: FROM igs_pe_person_base_v
2926: WHERE person_id = pcz_rec.person_id;
2927:

Line 2925: FROM igs_pe_person_base_v

2921: AND date_recognized = pcz_rec.date_recognized;
2922:
2923: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2924: SELECT birth_date
2925: FROM igs_pe_person_base_v
2926: WHERE person_id = pcz_rec.person_id;
2927:
2928: CURSOR date_overlap(PCZ_REC c_pcz%ROWTYPE) IS
2929: SELECT COUNT(1)

Line 2943: l_birth_dt IGS_PE_PERSON_V.BIRTH_DT%TYPE;

2939: ( TRUNC(PCZ_REC.date_recognized) < TRUNC(date_recognized) AND
2940: NVL(TRUNC(end_date),IGS_GE_DATE.igsdate('9999/01/01'))< NVL(TRUNC(PCZ_REC.end_date),IGS_GE_DATE.igsdate('9999/01/01')) ) );
2941:
2942: l_count NUMBER(3);
2943: l_birth_dt IGS_PE_PERSON_V.BIRTH_DT%TYPE;
2944: null_hndlg_rec c_null_hndlg%ROWTYPE;
2945: valid_country_rec c_valid_country%ROWTYPE;
2946:
2947: BEGIN