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_CANCEL_HIRE_OR_APL_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 801: per_person_type_usages_f ptu

797: -- Start Bug 3285486
798: CURSOR csr_get_ptu_id(p_system_person_type varchar2) IS
799: SELECT ptu.person_type_usage_id
800: FROM per_person_types pt,
801: per_person_type_usages_f ptu
802: WHERE pt.business_group_id = p_business_group_id
803: AND pt.person_type_id = ptu.person_type_id
804: AND p_primary_date BETWEEN ptu.effective_start_date
805: AND ptu.effective_end_date

Line 1140: from per_person_type_usages_f ptu

1136: ,p_system_person_type in varchar2
1137: ) is
1138: select ptu.person_type_usage_id
1139: ,ptu.object_version_number
1140: from per_person_type_usages_f ptu
1141: where p_effective_date between ptu.effective_start_date and ptu.effective_end_date
1142: and ptu.person_id = p_person_id
1143: and ptu.person_type_id in
1144: (select ppt.person_type_id

Line 1166: update per_person_type_usages_f ptu

1162: if csr_upded_person_type_usages%found then
1163:
1164: hr_utility.set_location('Entering Upd_Person_Type_Usage_End_Date',492);
1165:
1166: update per_person_type_usages_f ptu
1167: set effective_end_date = l_effective_end_date
1168: where ptu.effective_end_date = p_effective_date
1169: and ptu.person_id = p_person_id
1170: and ptu.person_type_usage_id = l_csr_upd_per_type_usages.person_type_usage_id

Line 1392: from per_person_type_usages_f ptu

1388: -- 3194314
1389: --
1390: cursor csr_emp_ptu_id is
1391: select ptu.person_type_id
1392: from per_person_type_usages_f ptu
1393: ,per_person_types ppt
1394: where ptu.person_id = p_person_id
1395: and ptu.effective_start_date = p_date_start
1396: and ptu.person_type_id = ppt.person_type_id

Line 1406: from per_person_type_usages_f ptu

1402: --3848352 start
1403: --
1404: cursor csr_apl_ptu_id is
1405: select ptu.person_type_id
1406: from per_person_type_usages_f ptu
1407: ,per_person_types ppt
1408: where ptu.person_id = p_person_id
1409: and ptu.effective_end_date = p_date_start - 1
1410: and ptu.person_type_id = ppt.person_type_id

Line 2227: --from per_person_type_usages_f ptu, per_person_types ppt

2223: -- person type usages cursor
2224: --
2225: --cursor person_type_usages2 is
2226: --select ptu.person_type_usage_id, ptu.object_version_number
2227: --from per_person_type_usages_f ptu, per_person_types ppt
2228: --where person_id = p_person_id
2229: --and ptu.person_type_id = ppt.person_type_id
2230: --and ppt.system_person_type = 'APL'
2231: --and ptu.effective_start_date = p_date_received;

Line 2295: from per_person_type_usages_f ptu

2291: --
2292: -- Bug 4095559: Cursor return whether B2B of EX_EMP/EX_CWK.APL
2293: cursor csr_b2b_apl is
2294: select count(ptu.person_type_id)
2295: from per_person_type_usages_f ptu
2296: ,per_person_types ppt
2297: where ptu.person_id = p_person_id
2298: and ptu.effective_start_date = p_date_received
2299: and ptu.person_type_id = ppt.person_type_id

Line 2322: from per_person_type_usages_f

2318: -- Bug 4095559: Cursor to get the latest person_type_id B2B of
2319: -- EX_EMP/EX_CWK.APL
2320: cursor latest_ptid is
2321: select person_type_id
2322: from per_person_type_usages_f
2323: where person_id = p_person_id
2324: order by EFFECTIVE_END_DATE desc, EFFECTIVE_START_DATE desc;
2325: --
2326: -- Cursor to re-evaluate the security.

Line 2771: delete from per_person_type_usages_f ptu

2767: ,p_system_person_type => 'APL');
2768:
2769: else
2770: -- Bug 4095559 : Delete the Applicant record from PTU
2771: delete from per_person_type_usages_f ptu
2772: where ptu.person_id = p_person_id
2773: and ptu.effective_start_date = p_date_received
2774: and ptu.person_type_id in (
2775: select ppt.person_type_id

Line 2953: per_person_type_usages_f ptu

2949: --
2950: CURSOR csr_get_ptu_id IS
2951: SELECT ptu.person_type_usage_id
2952: FROM per_person_types pt,
2953: per_person_type_usages_f ptu
2954: WHERE pt.business_group_id = p_business_group_id
2955: AND pt.person_type_id = ptu.person_type_id
2956: AND l_effective_date BETWEEN ptu.effective_start_date
2957: AND ptu.effective_end_date

Line 3282: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

3278: l_new_person_found BOOLEAN;
3279: l_person_rec_found BOOLEAN;
3280: l_effective_start_date DATE := NULL;
3281: l_effective_end_date DATE := NULL;
3282: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
3283: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
3284: c_effective_start_date date; --Added for the bug 6460093
3285: --
3286: -- events cursor

Line 3283: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

3279: l_person_rec_found BOOLEAN;
3280: l_effective_start_date DATE := NULL;
3281: l_effective_end_date DATE := NULL;
3282: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
3283: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
3284: c_effective_start_date date; --Added for the bug 6460093
3285: --
3286: -- events cursor
3287: --

Line 3505: FROM per_person_type_usages_f ptu,

3501:
3502: CURSOR csr_get_ptu_details IS
3503: SELECT ptu.person_type_usage_id,
3504: ptu.object_version_number
3505: FROM per_person_type_usages_f ptu,
3506: per_person_types pt
3507: WHERE ptu.person_id = p_person_id
3508: AND pt.person_type_id = ptu.person_type_Id
3509: AND pt.system_person_type = 'CWK'

Line 3894: UPDATE per_person_type_usages_f

3890: OPEN csr_get_cwk_type (p_sys_person_type => 'CWK');
3891: FETCH csr_get_cwk_type INTO l_person_type_id1;
3892: CLOSE csr_get_cwk_type;
3893:
3894: UPDATE per_person_type_usages_f
3895: SET person_type_id = l_person_type_id
3896: WHERE person_id = p_person_id
3897: AND person_type_id= l_person_type_id1
3898: AND p_date_start BETWEEN effective_start_date

Line 4052: -- then delete the current CWK record from per_person_type_usages_f

4048:
4049: --Change for the bug 6460093 ends here
4050:
4051: -- If there are back to back records for period of service
4052: -- then delete the current CWK record from per_person_type_usages_f
4053: -- table.
4054: --
4055: -- bug fix 6992346
4056: -- If there are back to back records for period of service