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.HR_PDT_BUS dependencies on PER_ALL_PEOPLE_F

Line 509: -- the from business group in per_all_people_f

505: -- ---------------------------------------------------------------------------
506: --
507: -- Desciption:
508: -- This procedures validates that the from person id exists on the start date in
509: -- the from business group in per_all_people_f
510: --
511: -- Pre-conditions :
512: -- None
513: --

Line 546: from per_all_people_f per,

542: l_api_updating boolean;
543: --
544: cursor csr_check_person(p_person_id number, p_effective_date in date) is
545: select 1
546: from per_all_people_f per,
547: per_periods_of_service pds
548: where per.person_id = p_person_id
549: and p_effective_date between
550: per.effective_start_date and per.effective_end_date

Line 628: -- start date in to business group in per_all_people_f, and the to_person_id is

624: -- ---------------------------------------------------------------------------
625: --
626: -- Desciption:
627: -- This procedures validates that if specified, the to person id exists on the
628: -- start date in to business group in per_all_people_f, and the to_person_id is
629: -- not of type EMP,CWK, or APL on the start_date or in the future
630: --
631: -- Pre-conditions :
632: -- None

Line 668: from per_all_people_f per

664: l_api_updating boolean;
665: --
666: cursor csr_check_person(p_person_id number) is
667: select per.person_id
668: from per_all_people_f per
669: where per.person_id = p_person_id
670: and p_start_date between
671: per.effective_start_date and per.effective_end_date
672: and per.business_group_id = p_to_business_group_id;

Line 1058: select min(effective_start_date) from per_all_people_f

1054:
1055: -- Declare Cursor
1056:
1057: cursor csr_get_min_st_date is
1058: select min(effective_start_date) from per_all_people_f
1059: where person_id = p_person_id;
1060:
1061: -- Declare Local Variables
1062:

Line 1131: from per_all_people_f

1127: l_dummy number;
1128: --
1129: cursor csr_check_fut_home_per is
1130: select 1
1131: from per_all_people_f
1132: where person_id = p_from_person_id
1133: and effective_start_date > nvl(p_end_date,hr_api.g_eot);
1134: --
1135: begin

Line 1325: l_numgen_method per_all_people_f.employee_number%type;

1321: --
1322: l_proc varchar2(72) := g_package||'chk_employee_number';
1323: l_api_updating boolean;
1324: l_dummy number;
1325: l_numgen_method per_all_people_f.employee_number%type;
1326: l_host_empnum per_all_people_f.employee_number%type;
1327: l_global_num_set fnd_profile_option_values.profile_option_value%type;
1328: --
1329: cursor csr_numgen_method is

Line 1326: l_host_empnum per_all_people_f.employee_number%type;

1322: l_proc varchar2(72) := g_package||'chk_employee_number';
1323: l_api_updating boolean;
1324: l_dummy number;
1325: l_numgen_method per_all_people_f.employee_number%type;
1326: l_host_empnum per_all_people_f.employee_number%type;
1327: l_global_num_set fnd_profile_option_values.profile_option_value%type;
1328: --
1329: cursor csr_numgen_method is
1330: select pbg.method_of_generation_emp_num

Line 1336: from per_all_people_f

1332: where pbg.business_group_id=p_to_business_group_id;
1333: --
1334: cursor csr_check_host_number is
1335: select employee_number
1336: from per_all_people_f
1337: where person_id = p_to_person_id
1338: and effective_end_date = hr_api.g_eot;
1339: --
1340: cursor csr_check_num_unique is

Line 1342: from per_all_people_f

1338: and effective_end_date = hr_api.g_eot;
1339: --
1340: cursor csr_check_num_unique is
1341: select 1
1342: from per_all_people_f
1343: where effective_end_date = hr_api.g_eot
1344: and employee_number=p_employee_number
1345: and business_group_id = p_to_business_group_id;
1346: --

Line 3209: from per_all_people_f

3205: l_sup_bg_id number;
3206: --
3207: cursor csr_party_id(p_per_id number) IS
3208: select party_id
3209: from per_all_people_f
3210: where person_id = p_per_id
3211: and p_start_date
3212: between effective_start_date
3213: and effective_end_date;

Line 3217: from per_all_people_f

3213: and effective_end_date;
3214: --
3215: cursor csr_check_sup is
3216: select 1
3217: from per_all_people_f
3218: where person_id = p_supervisor_id
3219: and p_start_date between
3220: effective_start_date and effective_end_date
3221: and nvl(current_employee_flag,'N') = 'Y';