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

Line 920: SELECT count('1') "VALID" from per_all_people_f pap

916: IS
917: /* Cursor to retrieve Defined Balance Id */
918: CURSOR csr_check_person_number
919: IS
920: SELECT count('1') "VALID" from per_all_people_f pap
921: where pap.person_id=val_person_id
922: AND pap.EMPLOYEE_NUMBER=val_person_number
923: AND pap.EFFECTIVE_START_DATE <= g_income_end_date
924: AND pap.EFFECTIVE_END_DATE > = g_income_start_date

Line 1895: l_person_id per_all_people_f.person_id%TYPE;

1891: l_local_unit_id_fetched NUMBER;
1892: l_eit_local_unit NUMBER;
1893: l_legal_employer_id_fetched NUMBER;
1894: -- Temp needed Variables
1895: l_person_id per_all_people_f.person_id%TYPE;
1896: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1897:
1898: -- Temp needed Variables
1899:

Line 1951: FROM per_all_people_f pap

1947: ,ft.territory_short_name
1948: ,ft.territory_code
1949: ,pap.effective_end_date
1950: ,pap.EMPLOYEE_NUMBER
1951: FROM per_all_people_f pap
1952: ,fnd_territories_vl ft
1953: WHERE pap.person_id = csr_v_person_id
1954: AND pap.per_information_category = 'SE'
1955: AND ft.obsolete_flag = 'N'

Line 1963: per_all_people_f pap

1959:
1960: /* SELECT pap.last_name, pap.pre_name_adjunct, pap.first_name
1961: , pap.national_identifier, pap.person_id
1962: FROM
1963: per_all_people_f pap
1964: WHERE pap.person_id = csr_v_person_id
1965: AND pap.per_information_category = 'SE'
1966: AND csr_v_effective_date BETWEEN pap.effective_start_date
1967: AND pap.effective_end_date;