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_TYPES

Line 800: FROM per_person_types pt,

796: --
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

Line 1145: from per_person_types ppt

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
1145: from per_person_types ppt
1146: where (( p_system_person_type = 'OTHER'
1147: and ppt.system_person_type = 'OTHER' )));
1148:
1149: l_csr_upd_per_type_usages csr_upded_person_type_usages%rowtype;

Line 1393: ,per_person_types ppt

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
1397: and ppt.system_person_type = 'EMP';

Line 1407: ,per_person_types ppt

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
1411: and ppt.system_person_type = 'APL';

Line 1853: from per_person_types

1849: then
1850: if l_person_end_date = hr_general.end_of_time then --#1998140
1851:
1852: select person_type_id into l_person_type_id
1853: from per_person_types
1854: where business_group_id = p_business_group_id
1855: and system_person_type = 'EX_EMP'
1856: and default_flag = 'Y';
1857:

Line 1889: from per_person_types

1885: ,p_system_person_type => 'EX_APL'
1886: )
1887: and l_apl_flag is not null then
1888: select person_type_id into l_person_type_id
1889: from per_person_types
1890: where business_group_id = p_business_group_id
1891: and system_person_type = 'APL'
1892: and default_flag = 'Y';
1893: else

Line 1895: from per_person_types

1891: and system_person_type = 'APL'
1892: and default_flag = 'Y';
1893: else
1894: select person_type_id into l_person_type_id
1895: from per_person_types
1896: where business_group_id = p_business_group_id
1897: and system_person_type = 'OTHER' -- EX_CWK but this is not maintained
1898: and default_flag = 'Y';
1899: end if;

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 2296: ,per_person_types ppt

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
2300: and ppt.system_person_type <> 'APL';

Line 2776: from per_person_types ppt

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
2776: from per_person_types ppt
2777: where ppt.system_person_type = 'APL');
2778:
2779: end if;
2780: -- Bug 4095559 Ends

Line 2952: FROM per_person_types pt,

2948: AND ppm.effective_start_date >= l_effective_date;
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

Line 3482: FROM per_person_types

3478: -- Change for the bug 6460093 ends here
3479:
3480: CURSOR csr_get_person_type (p_system_person_type IN CHAR) IS
3481: SELECT person_type_id
3482: FROM per_person_types
3483: WHERE business_group_id = p_business_group_id
3484: AND system_person_type = p_system_person_type
3485: AND default_flag = 'Y';
3486:

Line 3492: FROM per_person_types

3488: -- Changes start for the bug 7110731
3489:
3490: CURSOR csr_get_cwk_type (p_sys_person_type IN CHAR) IS
3491: SELECT person_type_id
3492: FROM per_person_types
3493: WHERE business_group_id = p_business_group_id
3494: AND system_person_type = p_sys_person_type
3495: AND default_flag = 'Y';
3496:

Line 3506: per_person_types pt

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'
3510: AND p_effective_date BETWEEN ptu.effective_start_date