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 78: from per_contact_extra_info_f

74: select 'Y'
75: from dual
76: where exists(
77: select null
78: from per_contact_extra_info_f
79: where contact_extra_info_id = p_contact_extra_info_id
80: and effective_start_date = p_effective_end_date + 1);
81: begin
82: if p_effective_start_date = p_effective_date then

Line 112: from per_contact_extra_info_f

108: select 'Y'
109: from dual
110: where exists(
111: select null
112: from per_contact_extra_info_f
113: where contact_extra_info_id = p_contact_extra_info_id
114: and effective_end_date = p_effective_start_date - 1);
115: begin
116: if p_effective_start_date = p_effective_date then

Line 744: from per_contact_extra_info_f

740: p_validation_end_date => l_ved);
741: --
742: select object_version_number
743: into p_rec.cei_object_version_number
744: from per_contact_extra_info_f
745: where contact_extra_info_id = p_rec.contact_extra_info_id
746: and effective_end_date = p_rec.effective_date - 1;
747: --
748: hr_contact_extra_info_api.delete_contact_extra_info(

Line 962: from per_contact_extra_info_f

958: p_validation_end_date => l_ved);
959: --
960: select object_version_number
961: into p_rec.cei_object_version_number
962: from per_contact_extra_info_f
963: where contact_extra_info_id = p_rec.contact_extra_info_id
964: and effective_end_date = p_rec.effective_date - 1;
965: --
966: hr_contact_extra_info_api.delete_contact_extra_info(

Line 1176: from per_contact_extra_info_f

1172: p_validation_end_date => l_ved);
1173: --
1174: select object_version_number
1175: into p_rec.cei_object_version_number
1176: from per_contact_extra_info_f
1177: where contact_extra_info_id = p_rec.contact_extra_info_id
1178: and effective_end_date = p_rec.effective_date - 1;
1179: --
1180: hr_contact_extra_info_api.delete_contact_extra_info(

Line 1640: per_contact_extra_info_f cei,

1636: fnd_number.canonical_to_number(cei.cei_information3) ESTIMATED_ANNUAL_INCOME,
1637: cei.cei_information6 DISABILITY_TYPE,
1638: cei.cei_information7 DISABILITY_DETAILS
1639: from per_contact_relationships ctr,
1640: per_contact_extra_info_f cei,
1641: per_addresses adrr,
1642: per_addresses adrc,
1643: per_all_people_f per
1644: where ctr.person_id = p_person_id

Line 1694: per_contact_extra_info_f cei,

1690: trim(substrb(decode(adrr2.address_id, null,
1691: adrc2.address_line1 || adrc2.address_line2 || adrc2.address_line3,
1692: adrr2.address_line1 || adrr2.address_line2 || adrr2.address_line3), 1, 240)) OE_ADDRESS
1693: from per_contact_relationships ctr,
1694: per_contact_extra_info_f cei,
1695: per_addresses adrr,
1696: per_addresses adrc,
1697: per_all_people_f per,
1698: per_contact_relationships ctr2,

Line 1751: per_contact_extra_info_f cei,

1747: cei.cei_information1 OCCUPATION,
1748: cei.cei_information2 OS_SALARY_PAYER_NAME,
1749: cei.cei_information3 OS_SALARY_PAYER_ADDRESS
1750: from per_all_people_f per,
1751: per_contact_extra_info_f cei,
1752: per_contact_relationships ctr
1753: where ctr.person_id = p_person_id
1754: and cei.contact_relationship_id = ctr.contact_relationship_id
1755: and cei.cei_information_category = 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'

Line 3052: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP

3048: --
3049: --
3050: -- Transfer the followings.
3051: --
3052: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
3053: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
3054: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
3055: --
3056: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be

Line 3053: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE

3049: --
3050: -- Transfer the followings.
3051: --
3052: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
3053: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
3054: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
3055: --
3056: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
3057: -- at first "Delele", "Update" and at last "Insert" to avoid API errors.

Line 3054: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS

3050: -- Transfer the followings.
3051: --
3052: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
3053: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
3054: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
3055: --
3056: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
3057: -- at first "Delele", "Update" and at last "Insert" to avoid API errors.
3058: --

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

3052: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
3053: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
3054: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
3055: --
3056: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
3057: -- at first "Delele", "Update" and at last "Insert" to avoid API errors.
3058: --
3059: -- "Delete" phase
3060: --

Line 3407: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP

3403: end loop;
3404: --
3405: -- Rollback Transfer the followings.
3406: --
3407: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
3408: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
3409: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
3410: --
3411: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be

Line 3408: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE

3404: --
3405: -- Rollback Transfer the followings.
3406: --
3407: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
3408: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
3409: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
3410: --
3411: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
3412: -- at first "Insert", "Update" and at last "Delete" to avoid API errors.

Line 3409: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS

3405: -- Rollback Transfer the followings.
3406: --
3407: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
3408: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
3409: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
3410: --
3411: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
3412: -- at first "Insert", "Update" and at last "Delete" to avoid API errors.
3413: --

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

3407: -- JP_DEF_DEP --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP
3408: -- JP_DEF_DEP_OE --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OE
3409: -- JP_DEF_DEP_OS --> PER_CONTACT_EXTRA_INFO_F.JP_DEF_DEP_OS
3410: --
3411: -- The transaction sequence into PER_CONTACT_EXTRA_INFO_F must be
3412: -- at first "Insert", "Update" and at last "Delete" to avoid API errors.
3413: --
3414: -- "Insert" phase
3415: --

Line 3570: from per_contact_extra_info_f cei

3566: where v.assignment_action_id = p_assignment_action_id
3567: and status <> 'D'
3568: and exists(
3569: select null
3570: from per_contact_extra_info_f cei
3571: where cei.contact_extra_info_id = v.contact_extra_info_id
3572: and p_expiry_date + 1
3573: between cei.effective_start_date and cei.effective_end_date)
3574: for update nowait;

Line 3584: from per_contact_extra_info_f cei

3580: where v.assignment_action_id = p_assignment_action_id
3581: and status <> 'D'
3582: and exists(
3583: select null
3584: from per_contact_extra_info_f cei
3585: where cei.contact_extra_info_id = v.contact_extra_info_id
3586: and p_expiry_date + 1
3587: between cei.effective_start_date and cei.effective_end_date)
3588: for update nowait;

Line 3598: from per_contact_extra_info_f cei

3594: where v.assignment_action_id = p_assignment_action_id
3595: and status <> 'D'
3596: and exists(
3597: select null
3598: from per_contact_extra_info_f cei
3599: where cei.contact_extra_info_id = v.contact_extra_info_id
3600: and p_expiry_date + 1
3601: between cei.effective_start_date and cei.effective_end_date)
3602: for update nowait;

Line 3842: from per_contact_extra_info_f cei

3838: where v.assignment_action_id = p_assignment_action_id
3839: and status <> 'D'
3840: and exists(
3841: select null
3842: from per_contact_extra_info_f cei
3843: where cei.contact_extra_info_id = v.contact_extra_info_id
3844: and p_expiry_date
3845: between cei.effective_start_date and cei.effective_end_date)
3846: for update nowait;

Line 3858: from per_contact_extra_info_f cei

3854: where v.assignment_action_id = p_assignment_action_id
3855: and status <> 'D'
3856: and exists(
3857: select null
3858: from per_contact_extra_info_f cei
3859: where cei.contact_extra_info_id = v.contact_extra_info_id
3860: and p_expiry_date
3861: between cei.effective_start_date and cei.effective_end_date)
3862: for update nowait;

Line 3874: from per_contact_extra_info_f cei

3870: where v.assignment_action_id = p_assignment_action_id
3871: and status <> 'D'
3872: and exists(
3873: select null
3874: from per_contact_extra_info_f cei
3875: where cei.contact_extra_info_id = v.contact_extra_info_id
3876: and p_expiry_date
3877: between cei.effective_start_date and cei.effective_end_date)
3878: for update nowait;