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_EN_VAL_API dependencies on IGS_PE_PERSON_ID_TYP

Line 12: -- ssaleem 17-Sept-2004 Bug No. 3787210 : Added Closed Ind in table IGS_PE_PERSON_ID_TYP

8: --smadathi 29-AUG-2001 Bug No. 1956374 .The function GENP_VAL_STRT_END_DT removed
9: --smadathi 24-AUG-2001 Bug No. 1956374 .The function GENP_VAL_SDTT_SESS removed
10: --msrinivi 24-AUG-2001 Bug No. 1956374 .The function GENP_SET_ROWID removed
11: --vrathi 18-may-2003 Bug No. 2928745 : end date check cursor modified to include person_id_type
12: -- ssaleem 17-Sept-2004 Bug No. 3787210 : Added Closed Ind in table IGS_PE_PERSON_ID_TYP
13: -------------------------------------------------------------------------------------------
14:
15:
16: --

Line 40: CURSOR c_pit (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS

36:
37: r_alternate_person_id IGS_PE_ALT_PERS_ID%ROWTYPE;
38: cst_pay_adv_no CONSTANT VARCHAR2(10) := 'PAY_ADV_NO';
39: v_dummy VARCHAR2(1);
40: CURSOR c_pit (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
41: SELECT 'x'
42: FROM IGS_PE_PERSON_ID_TYP pit
43: WHERE pit.person_id_type = cp_person_id_type AND
44: pit.s_person_id_type = cst_pay_adv_no AND

Line 42: FROM IGS_PE_PERSON_ID_TYP pit

38: cst_pay_adv_no CONSTANT VARCHAR2(10) := 'PAY_ADV_NO';
39: v_dummy VARCHAR2(1);
40: CURSOR c_pit (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
41: SELECT 'x'
42: FROM IGS_PE_PERSON_ID_TYP pit
43: WHERE pit.person_id_type = cp_person_id_type AND
44: pit.s_person_id_type = cst_pay_adv_no AND
45: pit.closed_ind = 'N' ;
46: BEGIN

Line 98: IGS_PE_PERSON_ID_TYP pit

94: v_dummy VARCHAR2(1);
95: CURSOR c_api_pit IS
96: SELECT 'x'
97: FROM IGS_PE_ALT_PERS_ID api,
98: IGS_PE_PERSON_ID_TYP pit
99: WHERE api.api_person_id = p_pay_advice_number AND
100: api.pe_person_id <> p_person_id AND
101: api.person_id_type = pit.person_id_type AND
102: pit.s_person_id_type = cst_pay_adv_no;

Line 240: AND A.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')

236: FROM IGS_PE_ALT_PERS_ID A,
237: IGS_PE_ALT_PERS_ID B
238: WHERE A.pe_person_id = cp_person_id
239: AND A.pe_person_id = B.pe_person_id
240: AND A.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')
241: AND B.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')
242: AND A.ROWID <> B.ROWID
243: AND A.START_DT < NVL(B.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD'))
244: AND NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) <> A.START_DT

Line 241: AND B.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')

237: IGS_PE_ALT_PERS_ID B
238: WHERE A.pe_person_id = cp_person_id
239: AND A.pe_person_id = B.pe_person_id
240: AND A.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')
241: AND B.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')
242: AND A.ROWID <> B.ROWID
243: AND A.START_DT < NVL(B.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD'))
244: AND NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) <> A.START_DT
245: AND NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) > B.START_DT

Line 259: AND PERSON_ID_TYPE IN ( select person_id_type from igs_pe_person_id_typ

255: IS
256: SELECT count('x')
257: FROM igs_pe_alt_pers_id
258: WHERE pe_person_id = cp_person_id
259: AND PERSON_ID_TYPE IN ( select person_id_type from igs_pe_person_id_typ
260: where S_PERSON_ID_TYPE='SSN' )
261: AND end_dt IS NULL
262: GROUP BY pe_person_id,PERSON_ID_TYPE;
263:

Line 290: p_format_mask IN igs_pe_person_id_typ.format_mask%TYPE,

286:
287: END val_ssn_overlap_api;
288:
289: FUNCTION fm_equal(
290: p_format_mask IN igs_pe_person_id_typ.format_mask%TYPE,
291: p_frmt_msk_copy IN igs_pe_person_id_typ.format_mask%TYPE)
292: RETURN BOOLEAN AS
293: ------------------------------------------------------------------------------------------
294: --Created by : sarakshi

Line 291: p_frmt_msk_copy IN igs_pe_person_id_typ.format_mask%TYPE)

287: END val_ssn_overlap_api;
288:
289: FUNCTION fm_equal(
290: p_format_mask IN igs_pe_person_id_typ.format_mask%TYPE,
291: p_frmt_msk_copy IN igs_pe_person_id_typ.format_mask%TYPE)
292: RETURN BOOLEAN AS
293: ------------------------------------------------------------------------------------------
294: --Created by : sarakshi
295: --Date created: 21-SEP-2001

Line 306: l_trans_s IGS_PE_PERSON_ID_TYP.FORMAT_MASK%TYPE := NULL;

302: --Change History:
303: --Who When What
304: ----------------------------------------------------------------------------------------------
305: l_str_len NUMBER := LENGTH(p_format_mask);
306: l_trans_s IGS_PE_PERSON_ID_TYP.FORMAT_MASK%TYPE := NULL;
307: l_chr VARCHAR2(1);
308: BEGIN
309: FOR i IN 1..l_str_len LOOP
310: l_chr := SUBSTR(p_format_mask,i,1);

Line 364: p_format_mask IN igs_pe_person_id_typ.format_mask%TYPE,

360:
361: END unformat_api;
362:
363: FUNCTION fm_equal_wrap(
364: p_format_mask IN igs_pe_person_id_typ.format_mask%TYPE,
365: p_frmt_msk_copy IN igs_pe_person_id_typ.format_mask%TYPE)
366: RETURN NUMBER AS
367: ------------------------------------------------------------------------------------------
368: --Created by : pkpatel

Line 365: p_frmt_msk_copy IN igs_pe_person_id_typ.format_mask%TYPE)

361: END unformat_api;
362:
363: FUNCTION fm_equal_wrap(
364: p_format_mask IN igs_pe_person_id_typ.format_mask%TYPE,
365: p_frmt_msk_copy IN igs_pe_person_id_typ.format_mask%TYPE)
366: RETURN NUMBER AS
367: ------------------------------------------------------------------------------------------
368: --Created by : pkpatel
369: --Date created: 29-Aug-2005