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_KW_MONTHLY_REPORTS dependencies on PER_ALL_PEOPLE_F

Line 416: ,per_all_people_f ppf /per_people_f ppf/

412: FROM per_all_assignments_f asg /*per_assignments_f asg*/
413: ,pay_assignment_actions paa
414: ,pay_payroll_actions ppa
415: ,hr_soft_coding_keyflex hscl
416: ,per_all_people_f ppf /*per_people_f ppf*/
417: WHERE asg.assignment_id = paa.assignment_id
418: AND asg.person_id = ppf.person_id
419: AND ppf.nationality = l_local_nationality
420: AND paa.payroll_action_id = ppa.payroll_action_id

Line 602: ,per_people_f ppf /per_all_people_f ppf/

598: FROM per_assignments_f asg /*per_all_assignments_f asg*/
599: ,pay_assignment_actions paa
600: ,pay_payroll_actions ppa
601: ,hr_soft_coding_keyflex hscl
602: ,per_people_f ppf /*per_all_people_f ppf*/
603: WHERE asg.assignment_id = paa.assignment_id
604: AND asg.person_id = ppf.person_id
605: AND ppf.nationality = l_local_nationality
606: AND paa.payroll_action_id = ppa.payroll_action_id

Line 625: FROM per_people_f ppf --per_all_people_f ppf

621: (p_person_id
622: ,l_effective_date
623: ,'DISPLAY_NAME'
624: ,l_user_format)
625: FROM per_people_f ppf --per_all_people_f ppf
626: WHERE person_id = p_person_id
627: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
628: rec_get_emp_name csr_get_emp_name%ROWTYPE;*/
629:

Line 647: l_full_name per_all_people_f.full_name%TYPE;

643: l_add_si_arr_id NUMBER;
644: l_add_si_val NUMBER;
645: l_input_date VARCHAR2(30);
646: l_curr_date VARCHAR2(30);
647: l_full_name per_all_people_f.full_name%TYPE;
648: l_total_amount NUMBER;
649: i NUMBER;
650: j NUMBER;
651: l_count NUMBER;

Line 1012: ,per_people_f ppf /per_all_people_f ppf/

1008: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1009: ,pay_assignment_actions paa
1010: ,pay_payroll_actions ppa
1011: ,hr_soft_coding_keyflex hscl
1012: ,per_people_f ppf /*per_all_people_f ppf*/
1013: WHERE asg.assignment_id = paa.assignment_id
1014: AND asg.person_id = ppf.person_id
1015: AND ppf.nationality = l_local_nationality
1016: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1035: FROM per_people_f ppf --per_all_people_f ppf

1031: (p_person_id
1032: ,l_effective_date
1033: ,'DISPLAY_NAME'
1034: ,l_user_format)
1035: FROM per_people_f ppf --per_all_people_f ppf
1036: WHERE person_id = p_person_id
1037: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1038: rec_get_emp_name csr_get_emp_name%ROWTYPE;*/
1039:

Line 1116: l_full_name per_all_people_f.full_name%TYPE;

1112: l_add_si_arr_id NUMBER;
1113: l_add_si_val NUMBER;
1114: l_input_date VARCHAR2(30);
1115: l_curr_date VARCHAR2(30);
1116: l_full_name per_all_people_f.full_name%TYPE;
1117: l_total_amount NUMBER;
1118: i NUMBER;
1119: j NUMBER;
1120: l_count NUMBER;

Line 1648: ,per_people_f ppf /per_all_people_f ppf/

1644: ,pay_assignment_actions paa
1645: ,pay_payroll_actions ppa
1646: ,hr_soft_coding_keyflex hscl
1647: ,per_periods_of_service pos
1648: ,per_people_f ppf /*per_all_people_f ppf*/
1649: WHERE asg.assignment_id = paa.assignment_id
1650: AND asg.person_id = ppf.person_id
1651: AND ppf.nationality = l_local_nationality
1652: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1678: ,per_people_f ppf /per_all_people_f ppf/

1674: ,pay_assignment_actions paa
1675: ,pay_payroll_actions ppa
1676: ,hr_soft_coding_keyflex hscl
1677: ,per_periods_of_service pos
1678: ,per_people_f ppf /*per_all_people_f ppf*/
1679: WHERE asg.assignment_id = paa.assignment_id
1680: AND asg.person_id = ppf.person_id
1681: AND ppf.nationality = l_local_nationality
1682: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1724: ,per_people_f ppf /per_all_people_f ppf/

1720: ,pay_assignment_actions paa
1721: ,pay_payroll_actions ppa
1722: ,hr_soft_coding_keyflex hscl
1723: ,per_periods_of_service pos
1724: ,per_people_f ppf /*per_all_people_f ppf*/
1725: WHERE asg.assignment_id = paa.assignment_id
1726: AND asg.person_id = ppf.person_id
1727: AND ppf.nationality = l_local_nationality
1728: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1753: FROM per_people_f ppf /per_all_people_f ppf/

1749: ,l_effective_date
1750: ,'DISPLAY_NAME'
1751: ,l_user_format)*/
1752: national_identifier
1753: FROM per_people_f ppf /*per_all_people_f ppf*/
1754: WHERE person_id = p_person_id
1755: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1756: rec_get_emp_name csr_get_emp_name%ROWTYPE;
1757:

Line 1764: l_full_name per_all_people_f.full_name%TYPE;

1760: l_employer_ssn NUMBER;
1761: l_subject_si_id NUMBER;
1762: l_subject_si_val NUMBER;
1763: l_input_date VARCHAR2(30);
1764: l_full_name per_all_people_f.full_name%TYPE;
1765: l_civil_id per_all_people_f.national_identifier%TYPE;
1766: l_salary_effective_date DATE;
1767: l_diff_exist NUMBER := 0;
1768: l_prev_salary NUMBER;

Line 1765: l_civil_id per_all_people_f.national_identifier%TYPE;

1761: l_subject_si_id NUMBER;
1762: l_subject_si_val NUMBER;
1763: l_input_date VARCHAR2(30);
1764: l_full_name per_all_people_f.full_name%TYPE;
1765: l_civil_id per_all_people_f.national_identifier%TYPE;
1766: l_salary_effective_date DATE;
1767: l_diff_exist NUMBER := 0;
1768: l_prev_salary NUMBER;
1769: l_new_count NUMBER;

APPS.PAY_KW_MONTHLY_REPORTS dependencies on PER_ALL_PEOPLE_F

Line 416: ,per_all_people_f ppf /*per_people_f ppf*/

Line 602: ,per_people_f ppf /*per_all_people_f ppf*/