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

Line 336: FROM per_all_people_f per

332: CURSOR c_check_per_status (p_person_id IN VARCHAR2 ,
333: p_effective_date IN VARCHAR2) IS
334:
335: SELECT per.current_applicant_flag
336: FROM per_all_people_f per
337: WHERE per.person_id = p_person_id
338: AND fnd_date.canonical_to_date(p_effective_date)
339: BETWEEN per.effective_start_date AND per.effective_end_date;
340:

Line 1249: FROM per_all_people_f ppf

1245:
1246: CURSOR c_person_detail (cp_person_id IN NUMBER
1247: ,cp_effective_date IN DATE) IS
1248: SELECT replace(ppf.per_information3,'-','') emp_ssnumber
1249: FROM per_all_people_f ppf
1250: WHERE ppf.person_id = cp_person_id
1251: -- Bug 6013218
1252: AND cp_effective_date BETWEEN ppf.effective_start_date AND
1253: ppf.effective_end_date;

Line 1256: FROM per_all_people_f ppf_in

1252: AND cp_effective_date BETWEEN ppf.effective_start_date AND
1253: ppf.effective_end_date;
1254: /*AND ppf.effective_start_date =
1255: ( SELECT max(ppf_in.effective_start_date)
1256: FROM per_all_people_f ppf_in
1257: WHERE ppf_in.person_id = ppf.person_id
1258: AND trunc(cp_end_date) >= ppf_in.effective_start_date
1259: AND trunc(cp_start_date) <= ppf_in.effective_end_date);*/
1260:

Line 2382: FROM per_all_people_f ppf

2378:
2379: CURSOR c_person_detail (cp_person_id IN NUMBER
2380: ,cp_effective_date IN DATE) IS
2381: SELECT replace(ppf.per_information3,'-','') emp_ssnumber
2382: FROM per_all_people_f ppf
2383: WHERE ppf.person_id = cp_person_id
2384: -- Bug 6013218
2385: AND cp_effective_date BETWEEN ppf.effective_start_date AND
2386: ppf.effective_end_date;

Line 2389: FROM per_all_people_f ppf_in

2385: AND cp_effective_date BETWEEN ppf.effective_start_date AND
2386: ppf.effective_end_date;
2387: /*AND ppf.effective_start_date =
2388: ( SELECT max(ppf_in.effective_start_date)
2389: FROM per_all_people_f ppf_in
2390: WHERE ppf_in.person_id = ppf.person_id
2391: AND trunc(cp_end_date) >= ppf_in.effective_start_date
2392: AND trunc(cp_start_date) <= ppf_in.effective_end_date);*/
2393:

Line 2455: FROM per_all_people_f per

2451: ,paf.business_group_id
2452: ,paf.soft_coding_keyflex_id
2453: ,cp_effective_date) = p_gre_id
2454: AND EXISTS (SELECT 1
2455: FROM per_all_people_f per
2456: WHERE per.person_id = paf.person_id
2457: AND cp_effective_date
2458: BETWEEN per.effective_start_date AND per.effective_end_date
2459: AND NVL(per.current_applicant_flag,'N') <> 'Y'

Line 2467: FROM per_all_people_f per

2463: CURSOR c_check_per_status (p_person_id IN VARCHAR2 ,
2464: p_effective_date IN VARCHAR2) IS
2465:
2466: SELECT per.current_applicant_flag
2467: FROM per_all_people_f per
2468: WHERE per.person_id = p_person_id
2469: AND fnd_date.canonical_to_date(p_effective_date)
2470: BETWEEN per.effective_start_date AND per.effective_end_date;
2471:

Line 3292: FROM per_all_people_f per

3288: ,business_group_id
3289: ,soft_coding_keyflex_id
3290: ,cp_effective_date) = p_gre_id
3291: AND EXISTS (SELECT 1
3292: FROM per_all_people_f per
3293: WHERE per.person_id = pa.person_id
3294: AND cp_effective_date
3295: BETWEEN per.effective_start_date AND per.effective_end_date
3296: AND NVL(per.current_applicant_flag,'N') <> 'Y');

Line 3444: ELSIF lv_table_name = 'PER_ALL_PEOPLE_F' THEN

3440:
3441: asg_count := asg_count + 1;
3442: asg_events(asg_count) := int_pkg_events(i);
3443:
3444: ELSIF lv_table_name = 'PER_ALL_PEOPLE_F' THEN
3445:
3446: per_count := per_count + 1;
3447: per_events(per_count) := int_pkg_events(i);
3448:

Line 3555: FROM per_all_people_f ppf

3551: ,ppf.employee_number worker_id
3552: ,ppf.national_identifier curp
3553: ,ppf.per_information2 tax_rfc_id
3554: ,fnd_date.date_to_canonical(ppf.effective_start_date) hire_date
3555: FROM per_all_people_f ppf
3556: WHERE ppf.person_id = cp_person_id
3557: AND ppf.effective_start_date =
3558: ( SELECT max(ppf_in.effective_start_date)
3559: FROM per_all_people_f ppf_in

Line 3559: FROM per_all_people_f ppf_in

3555: FROM per_all_people_f ppf
3556: WHERE ppf.person_id = cp_person_id
3557: AND ppf.effective_start_date =
3558: ( SELECT max(ppf_in.effective_start_date)
3559: FROM per_all_people_f ppf_in
3560: WHERE ppf_in.person_id = ppf.person_id
3561: AND ppf_in.effective_start_date <= cp_effective_date);
3562:
3563: CURSOR c_asg_detail ( cp_assignment_id IN NUMBER

Line 4660: FROM per_all_people_f per

4656: CURSOR c_check_active_employee (p_person_id IN VARCHAR2 ,
4657: p_effective_date IN VARCHAR2) IS
4658:
4659: SELECT 'Y'
4660: FROM per_all_people_f per
4661: WHERE per.person_id = p_person_id
4662: AND fnd_date.canonical_to_date(p_effective_date)
4663: BETWEEN per.effective_start_date AND per.effective_end_date
4664: AND per.current_employee_flag = 'Y';