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.BEN_ELIG_CVRD_DPNT_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 1133: from per_person_type_usages_f a,

1129: ,a.object_version_number
1130: ,a.person_type_id
1131: ,a.effective_start_date
1132: ,a.effective_end_date
1133: from per_person_type_usages_f a,
1134: per_person_types b
1135: where a.person_id = l_dpnt_person_id
1136: and a.person_type_id = b.person_type_id
1137: and b.system_person_type = 'DPNT'

Line 1149: from per_person_type_usages_f a,

1145: ,a.object_version_number
1146: ,a.person_type_id
1147: ,a.effective_start_date
1148: ,a.effective_end_date
1149: from per_person_type_usages_f a,
1150: per_person_types b
1151: where a.person_id = l_dpnt_person_id
1152: and a.person_type_id = b.person_type_id
1153: and b.system_person_type = 'DPNT'

Line 1220: update per_person_type_usages_f ptu

1216: for cur_rec in usage_c loop
1217: l_datetrack_mode := hr_api.g_correction;
1218: l_effective_end_date := hr_api.g_eot;
1219:
1220: update per_person_type_usages_f ptu
1221: set effective_end_date = l_effective_end_date
1222: where ptu.person_type_usage_id = cur_rec.person_type_usage_id
1223: and ptu.effective_start_date = cur_rec.effective_start_date;
1224:

Line 2376: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

2372: --
2373: l_person_type_id number(15);
2374: l_person_type_usage_id number(15);
2375: l_per_effective_start_date date;
2376: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2377: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2378: l1_person_type_usage_id number(15);
2379: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2380: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

Line 2377: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

2373: l_person_type_id number(15);
2374: l_person_type_usage_id number(15);
2375: l_per_effective_start_date date;
2376: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2377: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2378: l1_person_type_usage_id number(15);
2379: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2380: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2381: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

Line 2379: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

2375: l_per_effective_start_date date;
2376: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2377: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2378: l1_person_type_usage_id number(15);
2379: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2380: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2381: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
2382: --
2383: l_dpnt_person_id number(15);

Line 2380: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

2376: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2377: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2378: l1_person_type_usage_id number(15);
2379: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2380: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2381: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
2382: --
2383: l_dpnt_person_id number(15);
2384: l_cvg_strt_dt date;

Line 2381: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

2377: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2378: l1_person_type_usage_id number(15);
2379: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
2380: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
2381: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
2382: --
2383: l_dpnt_person_id number(15);
2384: l_cvg_strt_dt date;
2385: l_business_group_id number(15);

Line 2415: from per_person_type_usages_f a

2411: cursor find_ptu_ovlp_segments_c is
2412: select a.effective_start_date,
2413: a.effective_end_date,
2414: a.person_type_usage_id
2415: from per_person_type_usages_f a
2416: where a.person_id = l_dpnt_person_id
2417: and a.person_type_id = l_person_type_id
2418: -- and a.effective_start_date <= hr_api.g_date
2419: and a.effective_end_date >= l_cvg_strt_dt

Line 2490: update per_person_type_usages_f

2486: null;
2487: elsif l_effective_start_date <= l_cvg_strt_dt and
2488: l_effective_end_date < hr_api.g_eot
2489: then
2490: update per_person_type_usages_f
2491: set effective_end_date = hr_api.g_eot
2492: where person_type_usage_id = l_person_type_usage_id;
2493: elsif l_effective_start_date > l_cvg_strt_dt and
2494: l_effective_end_date = hr_api.g_eot then

Line 2496: update per_person_type_usages_f

2492: where person_type_usage_id = l_person_type_usage_id;
2493: elsif l_effective_start_date > l_cvg_strt_dt and
2494: l_effective_end_date = hr_api.g_eot then
2495: --
2496: update per_person_type_usages_f
2497: set effective_start_date = l_cvg_strt_dt
2498: where person_type_usage_id = l_person_type_usage_id;
2499: --
2500: elsif l_effective_start_date > l_cvg_strt_dt and

Line 2503: update per_person_type_usages_f

2499: --
2500: elsif l_effective_start_date > l_cvg_strt_dt and
2501: l_effective_end_date < hr_api.g_eot then
2502: --
2503: update per_person_type_usages_f
2504: set effective_start_date = l_cvg_strt_dt,
2505: effective_end_date = hr_api.g_eot
2506: where person_type_usage_id = l_person_type_usage_id;
2507: --

Line 2584: from per_person_type_usages_f a,

2580: select a.person_type_usage_id,
2581: a.object_version_number,
2582: a.effective_start_date,
2583: a.effective_end_date
2584: from per_person_type_usages_f a,
2585: per_person_types b
2586: where a.person_id = l_dpnt_person_id
2587: and a.person_type_id = b.person_type_id
2588: and b.system_person_type = 'DPNT'