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 24: type t_person_types is table of per_person_types.system_person_type%type;

20:
21: --
22: -- Declare Type
23: --
24: type t_person_types is table of per_person_types.system_person_type%type;
25:
26: --
27: -- Declare cursor
28: --

Line 31: from per_person_type_usages_f ptu, per_person_types ppt

27: -- Declare cursor
28: --
29: Cursor csr_person_types is
30: select ppt.system_person_type
31: from per_person_type_usages_f ptu, per_person_types ppt
32: where ptu.person_type_id = ppt.person_type_id
33: and person_id = p_person_id
34: and ppt.business_group_id = p_business_group_id
35: and ppt.system_person_type <> p_current_person_type

Line 41: from per_person_type_usages_f ptu, per_person_types ppt

37: and ppt.system_person_type in ('EMP','EX_EMP','APL','EX_APL','CWK','EX_CWK');
38:
39: Cursor csr_prev_person_types is
40: select ppt.system_person_type
41: from per_person_type_usages_f ptu, per_person_types ppt
42: where ptu.person_type_id = ppt.person_type_id
43: and person_id = p_person_id
44: and ppt.business_group_id = p_business_group_id
45: and ppt.system_person_type in ('EMP','EX_EMP','APL','EX_APL','CWK','EX_CWK')

Line 48: from per_person_type_usages_f ptu1, per_person_types ppt1

44: and ppt.business_group_id = p_business_group_id
45: and ppt.system_person_type in ('EMP','EX_EMP','APL','EX_APL','CWK','EX_CWK')
46: and ptu.effective_end_date =
47: (select effective_start_date - 1
48: from per_person_type_usages_f ptu1, per_person_types ppt1
49: where ptu1.person_type_id = ppt1.person_type_id
50: and ptu1.person_id = p_person_id
51: and ppt1.system_person_type = p_current_person_type
52: and p_effective_date between effective_start_date and effective_end_date)

Line 57: from per_all_people_f papf, per_person_types ppt

53: order by effective_end_date desc, effective_start_date desc;
54:
55: Cursor csr_prev_ppl_person_types is
56: select ppt.system_person_type
57: from per_all_people_f papf, per_person_types ppt
58: where papf.person_type_id = ppt.person_type_id
59: and person_id = p_person_id
60: and ppt.business_group_id = p_business_group_id
61: and ppt.system_person_type in

Line 71: from per_person_type_usages_f ptu1, per_person_types ppt1

67: 'EX_EMP_APL',
68: 'OTHER')
69: and papf.effective_end_date =
70: (select effective_start_date - 1
71: from per_person_type_usages_f ptu1, per_person_types ppt1
72: where ptu1.person_type_id = ppt1.person_type_id
73: and ptu1.person_id = p_person_id
74: and ppt.business_group_id = p_business_group_id
75: and ppt1.system_person_type = p_current_person_type

Line 1020: FROM per_person_types pt,

1016:
1017: -- Start Bug 3285486
1018: CURSOR csr_get_ptu_id(p_system_person_type varchar2) IS
1019: SELECT ptu.person_type_usage_id
1020: FROM per_person_types pt,
1021: per_person_type_usages_f ptu
1022: WHERE pt.business_group_id = p_business_group_id
1023: AND pt.person_type_id = ptu.person_type_id
1024: AND p_primary_date BETWEEN ptu.effective_start_date

Line 1576: FROM per_person_types pt,

1572:
1573:
1574: CURSOR csr_get_ptu_id IS
1575: SELECT ptu.person_type_usage_id
1576: FROM per_person_types pt,
1577: per_person_type_usages_f ptu
1578: WHERE pt.business_group_id = p_business_group_id
1579: AND pt.person_type_id = ptu.person_type_id
1580: AND p_date_start BETWEEN ptu.effective_start_date

Line 2037: from per_person_types ppt

2033: where p_effective_date between ptu.effective_start_date and ptu.effective_end_date
2034: and ptu.person_id = p_person_id
2035: and ptu.person_type_id in
2036: (select ppt.person_type_id
2037: from per_person_types ppt
2038: where (( p_system_person_type = 'OTHER'
2039: and ppt.system_person_type = 'OTHER' )));
2040:
2041: l_csr_upd_per_type_usages csr_upded_person_type_usages%rowtype;

Line 2095: l_system_person_type per_person_types.system_person_type%type; --added for bug 8405711

2091: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2092: -- End of fix 3564129
2093: --
2094:
2095: l_system_person_type per_person_types.system_person_type%type; --added for bug 8405711
2096: --
2097: -- supervisor cursor.
2098: --
2099: cursor supervisor1 is

Line 2313: ,per_person_types ppt

2309: --
2310: cursor csr_emp_ptu_id is
2311: select ptu.person_type_id
2312: from per_person_type_usages_f ptu
2313: ,per_person_types ppt
2314: where ptu.person_id = p_person_id
2315: and ptu.effective_start_date = p_date_start
2316: and ptu.person_type_id = ppt.person_type_id
2317: and ppt.system_person_type = 'EMP';

Line 2327: ,per_person_types ppt

2323: --
2324: cursor csr_apl_ptu_id is
2325: select ptu.person_type_id
2326: from per_person_type_usages_f ptu
2327: ,per_person_types ppt
2328: where ptu.person_id = p_person_id
2329: and ptu.effective_end_date = p_date_start - 1
2330: and ptu.person_type_id = ppt.person_type_id
2331: and ppt.system_person_type = 'APL';

Line 2807: from per_person_types

2803: then
2804: if l_person_end_date = hr_general.end_of_time then --#1998140
2805:
2806: select person_type_id into l_person_type_id
2807: from per_person_types
2808: where business_group_id = p_business_group_id
2809: and system_person_type = 'EX_EMP'
2810: and default_flag = 'Y';
2811:

Line 2816: from per_person_types

2812: -- code added for the bug 8504597 starts here
2813:
2814: if l_apl_flag = 'Y' then
2815: select person_type_id into l_person_type_id
2816: from per_person_types
2817: where business_group_id = p_business_group_id
2818: and system_person_type = 'EX_EMP_APL'
2819: and default_flag = 'Y';
2820: end if;

Line 2845: from per_person_types

2841: -- from per_ptu_bus.chk_person_type_id
2842:
2843: select person_type_id
2844: into l_person_type_id
2845: from per_person_types
2846: where business_group_id = p_business_group_id
2847: and system_person_type = 'EX_EMP'
2848: and default_flag = 'Y';
2849:

Line 2874: from per_person_types

2870: ,p_system_person_type => 'EX_APL'
2871: )
2872: and l_apl_flag is not null then
2873: select person_type_id into l_person_type_id
2874: from per_person_types
2875: where business_group_id = p_business_group_id
2876: and system_person_type = 'APL'
2877: and default_flag = 'Y';
2878: ELSE

Line 2889: from per_person_types

2885:
2886: l_person_type_id := hr_person_type_usage_info.get_default_person_type_id
2887: (p_business_group_id, l_system_person_type);
2888: /*select person_type_id into l_person_type_id
2889: from per_person_types
2890: where business_group_id = p_business_group_id
2891: and system_person_type = 'OTHER' -- EX_CWK but this is not maintained
2892: and default_flag = 'Y'; */
2893: -- end changes for bug 8405711

Line 3227: --from per_person_type_usages_f ptu, per_person_types ppt

3223: -- person type usages cursor
3224: --
3225: --cursor person_type_usages2 is
3226: --select ptu.person_type_usage_id, ptu.object_version_number
3227: --from per_person_type_usages_f ptu, per_person_types ppt
3228: --where person_id = p_person_id
3229: --and ptu.person_type_id = ppt.person_type_id
3230: --and ppt.system_person_type = 'APL'
3231: --and ptu.effective_start_date = p_date_received;

Line 3315: ,per_person_types ppt

3311: -- Bug 4095559: Cursor return whether B2B of EX_EMP/EX_CWK.APL
3312: cursor csr_b2b_apl is
3313: select count(ptu.person_type_id)
3314: from per_person_type_usages_f ptu
3315: ,per_person_types ppt
3316: where ptu.person_id = p_person_id
3317: and ptu.effective_start_date = p_date_received
3318: and ptu.person_type_id = ppt.person_type_id
3319: and ppt.system_person_type <> 'APL';

Line 3363: from per_person_types ppt

3359: where ptu.person_id = p_person_id
3360: and ptu.effective_end_date = p_date_received - 1
3361: and exists (
3362: select ppt.person_type_id
3363: from per_person_types ppt
3364: where ppt.system_person_type = 'APL'
3365: and ppt.business_group_id = p_business_group_id
3366: and ppt.person_type_id = ptu.person_type_id)
3367: and exists (select ppt1.person_type_id

Line 3368: from per_person_types ppt1, per_person_type_usages_f ptu1

3364: where ppt.system_person_type = 'APL'
3365: and ppt.business_group_id = p_business_group_id
3366: and ppt.person_type_id = ptu.person_type_id)
3367: and exists (select ppt1.person_type_id
3368: from per_person_types ppt1, per_person_type_usages_f ptu1
3369: where ptu1.person_type_id = ppt1.person_type_id
3370: and ppt1.business_group_id = p_business_group_id
3371: and ptu1.person_id = p_person_id
3372: and ppt1.system_person_type in ('EMP','CWK')

Line 3410: l_system_person_type per_person_types.system_person_type%type; --added for bug 8405711

3406: l_effective_start_date date; -- Bug 4095559
3407: l_current_applicant_flag VARCHAR2(30); -- Bug 4095559
3408: l_fut_per_chg boolean default false; -- Bug 4095559
3409: --
3410: l_system_person_type per_person_types.system_person_type%type; --added for bug 8405711
3411: l_action_perform_date date; --Bug 8405711
3412:
3413: begin
3414: --

Line 3914: from per_person_types ppt

3910: where ptu.person_id = p_person_id
3911: and ptu.effective_start_date = p_date_received
3912: and person_type_id in (
3913: select ppt.person_type_id
3914: from per_person_types ppt
3915: where business_group_id = p_business_group_id
3916: and ppt.system_person_type = 'APL');
3917: ELSE
3918: close chk_prv_APL_exists;

Line 3927: from per_person_types ppt

3923: where ptu.person_id = p_person_id
3924: and ptu.effective_start_date >= p_date_received
3925: and ptu.person_type_id in (
3926: select ppt.person_type_id
3927: from per_person_types ppt
3928: where ppt.system_person_type = 'APL'
3929: and business_group_id = p_business_group_id);
3930:
3931: -- start changes for bug 8405711

Line 3937: from per_person_types ppt

3933: set effective_end_date = to_date('31/12/4712','dd/mm/yyyy')
3934: where ptu.person_id = p_person_id
3935: and ptu.person_type_id in (
3936: select ppt.person_type_id
3937: from per_person_types ppt
3938: where ppt.system_person_type = 'EX_APL'
3939: and business_group_id = p_business_group_id)
3940: and ptu.effective_end_date = p_date_received - 1;
3941: -- end changes for bug 8405711

Line 4130: FROM per_person_types pt,

4126: AND ppm.effective_start_date >= l_effective_date;
4127: --
4128: CURSOR csr_get_ptu_id IS
4129: SELECT ptu.person_type_usage_id
4130: FROM per_person_types pt,
4131: per_person_type_usages_f ptu
4132: WHERE pt.business_group_id = p_business_group_id
4133: AND pt.person_type_id = ptu.person_type_id
4134: AND l_effective_date BETWEEN ptu.effective_start_date

Line 4498: l_cur_sys_person_type per_person_types.system_person_type%TYPE; --Added for the bug#13576986

4494: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
4495: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
4496: c_effective_start_date date; --Added for the bug 6460093
4497: --l_ex_apl_person_type_id per_person_type_usages_f.person_type_usage_id%TYPE; --Added for the bug#13442055 -- Commented for the bug#13576986
4498: l_cur_sys_person_type per_person_types.system_person_type%TYPE; --Added for the bug#13576986
4499: l_npw_number per_people_f.npw_number%TYPE; --Added for the bug#13772471
4500: --
4501: -- events cursor
4502: --

Line 4709: FROM per_person_types

4705: -- Change for the bug 6460093 ends here
4706:
4707: CURSOR csr_get_person_type (p_system_person_type IN CHAR) IS
4708: SELECT person_type_id
4709: FROM per_person_types
4710: WHERE business_group_id = p_business_group_id
4711: AND system_person_type = p_system_person_type
4712: AND default_flag = 'Y';
4713:

Line 4720: FROM per_person_types pt, per_person_type_usages_f ptu

4716: -- Changes start for the bug 7110731
4717:
4718: CURSOR csr_get_cwk_type (p_sys_person_type IN CHAR) IS
4719: SELECT pt.person_type_id
4720: FROM per_person_types pt, per_person_type_usages_f ptu
4721: WHERE pt.person_type_id = ptu.person_type_id
4722: AND pt.business_group_id = p_business_group_id
4723: AND pt.system_person_type = p_sys_person_type
4724: AND ptu.person_id = p_person_id

Line 4737: per_person_types pt

4733: CURSOR csr_get_ptu_details IS
4734: SELECT ptu.person_type_usage_id,
4735: ptu.object_version_number
4736: FROM per_person_type_usages_f ptu,
4737: per_person_types pt
4738: WHERE ptu.person_id = p_person_id
4739: AND pt.person_type_id = ptu.person_type_Id
4740: AND pt.system_person_type = 'CWK'
4741: AND p_effective_date BETWEEN ptu.effective_start_date

Line 4749: per_person_types pt

4745:
4746: CURSOR csr_is_apl_ex_apl IS
4747: SELECT pt.system_person_type
4748: FROM per_person_type_usages_f ptu,
4749: per_person_types pt
4750: WHERE ptu.person_id = p_person_id
4751: AND pt.person_type_id = ptu.person_type_Id
4752: AND pt.system_person_type in ('EX_APL','APL')
4753: --AND p_effective_date =ptu.effective_start_date; -- Commented for Bug#14166808

Line 4762: per_person_types pt

4758:
4759: /*CURSOR csr_is_ex_apl IS
4760: SELECT ptu.person_type_usage_id
4761: FROM per_person_type_usages_f ptu,
4762: per_person_types pt
4763: WHERE ptu.person_id = p_person_id
4764: AND pt.person_type_id = ptu.person_type_Id
4765: AND pt.system_person_type = 'EX_APL'
4766: AND p_effective_date =ptu.effective_start_date;*/