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

Line 71: from per_contact_extra_info_f

67: select 'Y'
68: from dual
69: where exists(
70: select null
71: from per_contact_extra_info_f
72: where contact_extra_info_id = p_contact_extra_info_id
73: and effective_start_date = p_effective_end_date + 1);
74: begin
75: if p_effective_start_date = p_effective_date then

Line 105: from per_contact_extra_info_f

101: select 'Y'
102: from dual
103: where exists(
104: select null
105: from per_contact_extra_info_f
106: where contact_extra_info_id = p_contact_extra_info_id
107: and effective_end_date = p_effective_start_date - 1);
108: begin
109: if p_effective_start_date = p_effective_date then

Line 724: from per_contact_extra_info_f

720: p_validation_end_date => l_ved);
721: --
722: select object_version_number
723: into p_rec.cei_object_version_number
724: from per_contact_extra_info_f
725: where contact_extra_info_id = p_rec.contact_extra_info_id
726: and effective_end_date = p_rec.effective_date - 1;
727: --
728: hr_contact_extra_info_api.delete_contact_extra_info(

Line 942: from per_contact_extra_info_f

938: p_validation_end_date => l_ved);
939: --
940: select object_version_number
941: into p_rec.cei_object_version_number
942: from per_contact_extra_info_f
943: where contact_extra_info_id = p_rec.contact_extra_info_id
944: and effective_end_date = p_rec.effective_date - 1;
945: --
946: hr_contact_extra_info_api.delete_contact_extra_info(

Line 1156: from per_contact_extra_info_f

1152: p_validation_end_date => l_ved);
1153: --
1154: select object_version_number
1155: into p_rec.cei_object_version_number
1156: from per_contact_extra_info_f
1157: where contact_extra_info_id = p_rec.contact_extra_info_id
1158: and effective_end_date = p_rec.effective_date - 1;
1159: --
1160: hr_contact_extra_info_api.delete_contact_extra_info(

Line 1379: per_contact_extra_info_f cei,

1375: cei.cei_information7 DISABILITY_DETAILS
1376: from per_all_people_f per,
1377: per_addresses adrc,
1378: per_addresses adrr,
1379: per_contact_extra_info_f cei,
1380: per_contact_relationships ctr
1381: where ctr.person_id = p_person_id
1382: and cei.contact_relationship_id = ctr.contact_relationship_id
1383: and cei.cei_information_category = 'JP_ITAX_DEPENDENT'

Line 1437: per_contact_extra_info_f cei,

1433: per_contact_relationships ctr2,
1434: per_all_people_f per,
1435: per_addresses adrc,
1436: per_addresses adrr,
1437: per_contact_extra_info_f cei,
1438: per_contact_relationships ctr
1439: where ctr.person_id = p_person_id
1440: and cei.contact_relationship_id = ctr.contact_relationship_id
1441: and cei.cei_information_category = 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'

Line 1489: per_contact_extra_info_f cei,

1485: cei.cei_information1 OCCUPATION,
1486: cei.cei_information2 OS_SALARY_PAYER_NAME,
1487: cei.cei_information3 OS_SALARY_PAYER_ADDRESS
1488: from per_all_people_f per,
1489: per_contact_extra_info_f cei,
1490: per_contact_relationships ctr
1491: where ctr.person_id = p_person_id
1492: and cei.contact_relationship_id = ctr.contact_relationship_id
1493: and cei.cei_information_category = 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'

Line 2367: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP

2363: end loop;
2364: --
2365: -- Transfer the followings.
2366: --
2367: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
2368: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
2369: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
2370: --
2371: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be

Line 2368: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE

2364: --
2365: -- Transfer the followings.
2366: --
2367: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
2368: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
2369: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
2370: --
2371: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
2372: -- at first "Delele", "Update" and at last "Insert" to avoid API errors.

Line 2369: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS

2365: -- Transfer the followings.
2366: --
2367: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
2368: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
2369: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
2370: --
2371: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
2372: -- at first "Delele", "Update" and at last "Insert" to avoid API errors.
2373: --

Line 2371: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be

2367: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
2368: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
2369: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
2370: --
2371: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
2372: -- at first "Delele", "Update" and at last "Insert" to avoid API errors.
2373: --
2374: -- "Delete" phase
2375: --

Line 2637: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP

2633: end loop;
2634: --
2635: -- Rollback Transfer the followings.
2636: --
2637: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
2638: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
2639: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
2640: --
2641: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be

Line 2638: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE

2634: --
2635: -- Rollback Transfer the followings.
2636: --
2637: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
2638: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
2639: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
2640: --
2641: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
2642: -- at first "Insert", "Update" and at last "Delete" to avoid API errors.

Line 2639: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS

2635: -- Rollback Transfer the followings.
2636: --
2637: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
2638: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
2639: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
2640: --
2641: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
2642: -- at first "Insert", "Update" and at last "Delete" to avoid API errors.
2643: --

Line 2641: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be

2637: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
2638: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
2639: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
2640: --
2641: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
2642: -- at first "Insert", "Update" and at last "Delete" to avoid API errors.
2643: --
2644: -- "Insert" phase
2645: --

Line 2759: from per_contact_extra_info_f cei

2755: where v.assignment_action_id = p_assignment_action_id
2756: and status <> 'D'
2757: and exists(
2758: select null
2759: from per_contact_extra_info_f cei
2760: where cei.contact_extra_info_id = v.contact_extra_info_id
2761: and p_expiry_date + 1
2762: between cei.effective_start_date and cei.effective_end_date)
2763: for update nowait;

Line 2771: from per_contact_extra_info_f cei

2767: where v.assignment_action_id = p_assignment_action_id
2768: and status <> 'D'
2769: and exists(
2770: select null
2771: from per_contact_extra_info_f cei
2772: where cei.contact_extra_info_id = v.contact_extra_info_id
2773: and p_expiry_date + 1
2774: between cei.effective_start_date and cei.effective_end_date)
2775: for update nowait;

Line 2783: from per_contact_extra_info_f cei

2779: where v.assignment_action_id = p_assignment_action_id
2780: and status <> 'D'
2781: and exists(
2782: select null
2783: from per_contact_extra_info_f cei
2784: where cei.contact_extra_info_id = v.contact_extra_info_id
2785: and p_expiry_date + 1
2786: between cei.effective_start_date and cei.effective_end_date)
2787: for update nowait;

Line 2965: from per_contact_extra_info_f cei

2961: where v.assignment_action_id = p_assignment_action_id
2962: and status <> 'D'
2963: and exists(
2964: select null
2965: from per_contact_extra_info_f cei
2966: where cei.contact_extra_info_id = v.contact_extra_info_id
2967: and p_expiry_date
2968: between cei.effective_start_date and cei.effective_end_date)
2969: for update nowait;

Line 2979: from per_contact_extra_info_f cei

2975: where v.assignment_action_id = p_assignment_action_id
2976: and status <> 'D'
2977: and exists(
2978: select null
2979: from per_contact_extra_info_f cei
2980: where cei.contact_extra_info_id = v.contact_extra_info_id
2981: and p_expiry_date
2982: between cei.effective_start_date and cei.effective_end_date)
2983: for update nowait;

Line 2993: from per_contact_extra_info_f cei

2989: where v.assignment_action_id = p_assignment_action_id
2990: and status <> 'D'
2991: and exists(
2992: select null
2993: from per_contact_extra_info_f cei
2994: where cei.contact_extra_info_id = v.contact_extra_info_id
2995: and p_expiry_date
2996: between cei.effective_start_date and cei.effective_end_date)
2997: for update nowait;