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 372: FROM per_all_people_f per

368: CURSOR c_check_per_status (p_person_id IN VARCHAR2 ,
369: p_effective_date IN VARCHAR2) IS
370:
371: SELECT per.current_applicant_flag
372: FROM per_all_people_f per
373: WHERE per.person_id = p_person_id
374: AND fnd_date.canonical_to_date(p_effective_date)
375: BETWEEN per.effective_start_date AND per.effective_end_date;
376:

Line 1324: FROM per_all_people_f ppf

1320:
1321: CURSOR c_person_detail (cp_person_id IN NUMBER
1322: ,cp_effective_date IN DATE) IS
1323: SELECT replace(ppf.per_information3,'-','') emp_ssnumber
1324: FROM per_all_people_f ppf
1325: WHERE ppf.person_id = cp_person_id
1326: -- Bug 6013218
1327: AND cp_effective_date BETWEEN ppf.effective_start_date AND
1328: ppf.effective_end_date;

Line 1331: FROM per_all_people_f ppf_in

1327: AND cp_effective_date BETWEEN ppf.effective_start_date AND
1328: ppf.effective_end_date;
1329: /*AND ppf.effective_start_date =
1330: ( SELECT max(ppf_in.effective_start_date)
1331: FROM per_all_people_f ppf_in
1332: WHERE ppf_in.person_id = ppf.person_id
1333: AND trunc(cp_end_date) >= ppf_in.effective_start_date
1334: AND trunc(cp_start_date) <= ppf_in.effective_end_date);*/
1335:

Line 2506: FROM per_all_people_f ppf

2502:
2503: CURSOR c_person_detail (cp_person_id IN NUMBER
2504: ,cp_effective_date IN DATE) IS
2505: SELECT replace(ppf.per_information3,'-','') emp_ssnumber
2506: FROM per_all_people_f ppf
2507: WHERE ppf.person_id = cp_person_id
2508: -- Bug 6013218
2509: AND cp_effective_date BETWEEN ppf.effective_start_date AND
2510: ppf.effective_end_date;

Line 2513: FROM per_all_people_f ppf_in

2509: AND cp_effective_date BETWEEN ppf.effective_start_date AND
2510: ppf.effective_end_date;
2511: /*AND ppf.effective_start_date =
2512: ( SELECT max(ppf_in.effective_start_date)
2513: FROM per_all_people_f ppf_in
2514: WHERE ppf_in.person_id = ppf.person_id
2515: AND trunc(cp_end_date) >= ppf_in.effective_start_date
2516: AND trunc(cp_start_date) <= ppf_in.effective_end_date);*/
2517:

Line 2579: FROM per_all_people_f per

2575: ,paf.business_group_id
2576: ,paf.soft_coding_keyflex_id
2577: ,cp_effective_date) = p_gre_id
2578: AND EXISTS (SELECT 1
2579: FROM per_all_people_f per
2580: WHERE per.person_id = paf.person_id
2581: AND cp_effective_date
2582: BETWEEN per.effective_start_date AND per.effective_end_date
2583: AND NVL(per.current_applicant_flag,'N') <> 'Y'

Line 2591: FROM per_all_people_f per

2587: CURSOR c_check_per_status (p_person_id IN VARCHAR2 ,
2588: p_effective_date IN VARCHAR2) IS
2589:
2590: SELECT per.current_applicant_flag
2591: FROM per_all_people_f per
2592: WHERE per.person_id = p_person_id
2593: AND fnd_date.canonical_to_date(p_effective_date)
2594: BETWEEN per.effective_start_date AND per.effective_end_date;
2595:

Line 3494: FROM per_all_people_f per

3490: ,business_group_id
3491: ,soft_coding_keyflex_id
3492: ,cp_effective_date) = p_gre_id
3493: AND EXISTS (SELECT 1
3494: FROM per_all_people_f per
3495: WHERE per.person_id = pa.person_id
3496: AND cp_effective_date
3497: BETWEEN per.effective_start_date AND per.effective_end_date
3498: AND NVL(per.current_applicant_flag,'N') <> 'Y');

Line 3649: ELSIF lv_table_name = 'PER_ALL_PEOPLE_F' THEN

3645:
3646: asg_count := asg_count + 1;
3647: asg_events(asg_count) := int_pkg_events(i);
3648:
3649: ELSIF lv_table_name = 'PER_ALL_PEOPLE_F' THEN
3650:
3651: per_count := per_count + 1;
3652: per_events(per_count) := int_pkg_events(i);
3653:

Line 3768: FROM per_all_people_f ppf

3764: ,ppf.employee_number worker_id
3765: ,ppf.national_identifier curp
3766: ,ppf.per_information2 tax_rfc_id
3767: ,fnd_date.date_to_canonical(ppf.effective_start_date) hire_date
3768: FROM per_all_people_f ppf
3769: WHERE ppf.person_id = cp_person_id
3770: AND ppf.effective_start_date =
3771: ( SELECT max(ppf_in.effective_start_date)
3772: FROM per_all_people_f ppf_in

Line 3772: FROM per_all_people_f ppf_in

3768: FROM per_all_people_f ppf
3769: WHERE ppf.person_id = cp_person_id
3770: AND ppf.effective_start_date =
3771: ( SELECT max(ppf_in.effective_start_date)
3772: FROM per_all_people_f ppf_in
3773: WHERE ppf_in.person_id = ppf.person_id
3774: AND ppf_in.effective_start_date <= cp_effective_date);
3775:
3776: CURSOR c_asg_detail ( cp_assignment_id IN NUMBER

Line 5127: FROM per_all_people_f per

5123: CURSOR c_check_active_employee (p_person_id IN VARCHAR2 ,
5124: p_effective_date IN VARCHAR2) IS
5125:
5126: SELECT 'Y'
5127: FROM per_all_people_f per
5128: WHERE per.person_id = p_person_id
5129: AND fnd_date.canonical_to_date(p_effective_date)
5130: BETWEEN per.effective_start_date AND per.effective_end_date
5131: AND per.current_employee_flag = 'Y';