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.PER_JP_CONTACT_EXTRA_INFO dependencies on PER_CONTACT_EXTRA_INFO_F

Line 22: from per_contact_extra_info_f

18: l_duplicate varchar2(1);
19: --
20: cursor csr_itax is
21: select 'Y'
22: from per_contact_extra_info_f
23: where contact_relationship_id = p_contact_relationship_id
24: and contact_extra_info_id <> p_contact_extra_info_id
25: and information_type in ('JP_ITAX_DEPENDENT', 'JP_ITAX_DEPENDENT_ON_OTHER_EMP', 'JP_ITAX_DEPENDENT_ON_OTHER_PAY')
26: and information_type <> p_information_type

Line 32: from per_contact_extra_info_f

28: and effective_start_date <= p_validation_end_date;
29: --
30: cursor csr_si is
31: select 'Y'
32: from per_contact_extra_info_f
33: where contact_relationship_id = p_contact_relationship_id
34: and contact_extra_info_id <> p_contact_extra_info_id
35: and information_type in ('JP_HI_SPOUSE', 'JP_HI_DEPENDENT')
36: and information_type <> p_information_type

Line 136: SELECT 'Y' FROM per_contact_extra_info_f

132: p_effective_date DATE,
133: p_contact_relationship_id NUMBER,
134: p_information_type VARCHAR2) IS
135: --
136: SELECT 'Y' FROM per_contact_extra_info_f
137: WHERE contact_relationship_id = p_contact_relationship_id
138: AND information_type LIKE 'JP_ITAX%'
139: AND information_type <> p_information_type
140: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 147: SELECT 'Y' FROM per_contact_extra_info_f

143: p_effective_date DATE,
144: p_contact_relationship_id NUMBER,
145: p_information_type VARCHAR2) IS
146: --
147: SELECT 'Y' FROM per_contact_extra_info_f
148: WHERE contact_relationship_id = p_contact_relationship_id
149: AND information_type LIKE 'JP_HI%'
150: AND information_type <> p_information_type
151: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 242: SELECT 'Y' FROM per_contact_extra_info_f

238: p_effective_date DATE,
239: p_contact_relationship_id NUMBER,
240: p_information_type VARCHAR2) IS
241: --
242: SELECT 'Y' FROM per_contact_extra_info_f
243: WHERE contact_relationship_id = p_contact_relationship_id
244: AND information_type LIKE 'JP_ITAX%'
245: AND information_type <> p_information_type
246: AND p_effective_date < effective_start_date;

Line 253: SELECT 'Y' FROM per_contact_extra_info_f

249: p_effective_date DATE,
250: p_contact_relationship_id NUMBER,
251: p_information_type VARCHAR2) IS
252: --
253: SELECT 'Y' FROM per_contact_extra_info_f
254: WHERE contact_relationship_id = p_contact_relationship_id
255: AND information_type LIKE 'JP_HI%'
256: AND information_type <> p_information_type
257: AND p_effective_date < effective_start_date;

Line 343: SELECT contact_relationship_id, information_type FROM per_contact_extra_info_f

339: p_contact_extra_info_id NUMBER,
340: p_datetrack_delete_mode VARCHAR2) IS
341: --
342: CURSOR cel_information_type IS
343: SELECT contact_relationship_id, information_type FROM per_contact_extra_info_f
344: WHERE contact_extra_info_id = p_contact_extra_info_id
345: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
346: --
347: CURSOR cel_itax_future_exists(

Line 351: SELECT 'Y' FROM per_contact_extra_info_f

347: CURSOR cel_itax_future_exists(
348: p_contact_relationship_id NUMBER,
349: p_information_type VARCHAR2) IS
350: --
351: SELECT 'Y' FROM per_contact_extra_info_f
352: WHERE information_type LIKE 'JP_ITAX%'
353: AND information_type <> p_information_type
354: AND contact_relationship_id = p_contact_relationship_id
355: AND p_effective_date < effective_start_date;

Line 361: SELECT 'Y' FROM per_contact_extra_info_f

357: CURSOR cel_hi_future_exists(
358: p_contact_relationship_id NUMBER,
359: p_information_type VARCHAR2) IS
360: --
361: SELECT 'Y' FROM per_contact_extra_info_f
362: WHERE information_type LIKE 'JP_HI%'
363: AND information_type <> p_information_type
364: AND contact_relationship_id = p_contact_relationship_id
365: AND p_effective_date < effective_start_date;

Line 367: l_contact_relationship_id per_contact_extra_info_f.contact_relationship_id%TYPE;

363: AND information_type <> p_information_type
364: AND contact_relationship_id = p_contact_relationship_id
365: AND p_effective_date < effective_start_date;
366: --
367: l_contact_relationship_id per_contact_extra_info_f.contact_relationship_id%TYPE;
368: l_information_type per_contact_extra_info_f.information_type%TYPE;
369: l_dummy VARCHAR2(1);
370: --
371: BEGIN

Line 368: l_information_type per_contact_extra_info_f.information_type%TYPE;

364: AND contact_relationship_id = p_contact_relationship_id
365: AND p_effective_date < effective_start_date;
366: --
367: l_contact_relationship_id per_contact_extra_info_f.contact_relationship_id%TYPE;
368: l_information_type per_contact_extra_info_f.information_type%TYPE;
369: l_dummy VARCHAR2(1);
370: --
371: BEGIN
372: --

Line 653: per_contact_extra_info_f pceif

649: pcr.contact_type
650: FROM
651: per_all_people_f papf,
652: per_contact_relationships pcr,
653: per_contact_extra_info_f pceif
654: WHERE pcr.contact_relationship_id = p_contact_relationship_id
655: AND pcr.contact_person_id = papf.person_id
656: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
657: AND pcr.contact_relationship_id = pceif.contact_relationship_id