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 484: ,per_all_people_f ppf /per_people_f ppf/

480: FROM per_all_assignments_f asg /*per_assignments_f asg*/
481: ,pay_assignment_actions paa
482: ,pay_payroll_actions ppa
483: ,hr_soft_coding_keyflex hscl
484: ,per_all_people_f ppf /*per_people_f ppf*/
485: WHERE asg.assignment_id = paa.assignment_id
486: AND asg.person_id = ppf.person_id
487: AND ppf.nationality = l_local_nationality
488: AND paa.payroll_action_id = ppa.payroll_action_id

Line 753: ,per_people_f ppf /per_all_people_f ppf/

749: FROM per_assignments_f asg /*per_all_assignments_f asg*/
750: ,pay_assignment_actions paa
751: ,pay_payroll_actions ppa
752: ,hr_soft_coding_keyflex hscl
753: ,per_people_f ppf /*per_all_people_f ppf*/
754: WHERE asg.assignment_id = paa.assignment_id
755: AND asg.person_id = ppf.person_id
756: AND ppf.nationality = l_local_nationality
757: AND paa.payroll_action_id = ppa.payroll_action_id

Line 776: FROM per_people_f ppf --per_all_people_f ppf

772: (p_person_id
773: ,l_effective_date
774: ,'DISPLAY_NAME'
775: ,l_user_format)
776: FROM per_people_f ppf --per_all_people_f ppf
777: WHERE person_id = p_person_id
778: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
779: rec_get_emp_name csr_get_emp_name%ROWTYPE;*/
780:

Line 798: l_full_name per_all_people_f.full_name%TYPE;

794: l_add_si_arr_id NUMBER;
795: l_add_si_val NUMBER;
796: l_input_date VARCHAR2(30);
797: l_curr_date VARCHAR2(30);
798: l_full_name per_all_people_f.full_name%TYPE;
799: l_total_amount NUMBER;
800: i NUMBER;
801: j NUMBER;
802: l_count NUMBER;

Line 1163: ,per_people_f ppf /per_all_people_f ppf/

1159: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1160: ,pay_assignment_actions paa
1161: ,pay_payroll_actions ppa
1162: ,hr_soft_coding_keyflex hscl
1163: ,per_people_f ppf /*per_all_people_f ppf*/
1164: WHERE asg.assignment_id = paa.assignment_id
1165: AND asg.person_id = ppf.person_id
1166: AND ppf.nationality = l_local_nationality
1167: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1186: FROM per_people_f ppf --per_all_people_f ppf

1182: (p_person_id
1183: ,l_effective_date
1184: ,'DISPLAY_NAME'
1185: ,l_user_format)
1186: FROM per_people_f ppf --per_all_people_f ppf
1187: WHERE person_id = p_person_id
1188: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1189: rec_get_emp_name csr_get_emp_name%ROWTYPE;*/
1190:

Line 1267: l_full_name per_all_people_f.full_name%TYPE;

1263: l_add_si_arr_id NUMBER;
1264: l_add_si_val NUMBER;
1265: l_input_date VARCHAR2(30);
1266: l_curr_date VARCHAR2(30);
1267: l_full_name per_all_people_f.full_name%TYPE;
1268: l_total_amount NUMBER;
1269: i NUMBER;
1270: j NUMBER;
1271: l_count NUMBER;

Line 1806: ,per_people_f ppf /per_all_people_f ppf/

1802: ,pay_assignment_actions paa
1803: ,pay_payroll_actions ppa
1804: ,hr_soft_coding_keyflex hscl
1805: ,per_periods_of_service pos
1806: ,per_people_f ppf /*per_all_people_f ppf*/
1807: WHERE asg.assignment_id = paa.assignment_id
1808: AND asg.person_id = ppf.person_id
1809: AND ppf.nationality = l_local_nationality
1810: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1836: ,per_people_f ppf /per_all_people_f ppf/

1832: ,pay_assignment_actions paa
1833: ,pay_payroll_actions ppa
1834: ,hr_soft_coding_keyflex hscl
1835: ,per_periods_of_service pos
1836: ,per_people_f ppf /*per_all_people_f ppf*/
1837: WHERE asg.assignment_id = paa.assignment_id
1838: AND asg.person_id = ppf.person_id
1839: AND ppf.nationality = l_local_nationality
1840: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1883: ,per_people_f ppf /per_all_people_f ppf/

1879: ,pay_assignment_actions paa
1880: ,pay_payroll_actions ppa
1881: ,hr_soft_coding_keyflex hscl
1882: ,per_periods_of_service pos
1883: ,per_people_f ppf /*per_all_people_f ppf*/
1884: WHERE asg.assignment_id = paa.assignment_id
1885: AND asg.person_id = ppf.person_id
1886: AND ppf.nationality = l_local_nationality
1887: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1912: FROM per_people_f ppf /per_all_people_f ppf/

1908: ,l_effective_date
1909: ,'DISPLAY_NAME'
1910: ,l_user_format)*/
1911: national_identifier
1912: FROM per_people_f ppf /*per_all_people_f ppf*/
1913: WHERE person_id = p_person_id
1914: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1915: rec_get_emp_name csr_get_emp_name%ROWTYPE;
1916:

Line 1970: l_full_name per_all_people_f.full_name%TYPE;

1966: l_employer_ssn NUMBER;
1967: l_subject_si_id NUMBER;
1968: l_subject_si_val NUMBER;
1969: l_input_date VARCHAR2(30);
1970: l_full_name per_all_people_f.full_name%TYPE;
1971: l_civil_id per_all_people_f.national_identifier%TYPE;
1972: l_salary_effective_date DATE;
1973: l_diff_exist NUMBER := 0;
1974: l_prev_salary NUMBER;

Line 1971: l_civil_id per_all_people_f.national_identifier%TYPE;

1967: l_subject_si_id NUMBER;
1968: l_subject_si_val NUMBER;
1969: l_input_date VARCHAR2(30);
1970: l_full_name per_all_people_f.full_name%TYPE;
1971: l_civil_id per_all_people_f.national_identifier%TYPE;
1972: l_salary_effective_date DATE;
1973: l_diff_exist NUMBER := 0;
1974: l_prev_salary NUMBER;
1975: l_new_count NUMBER;

APPS.PAY_KW_MONTHLY_REPORTS dependencies on PER_ALL_PEOPLE_F

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

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