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 926: SELECT count('1') "VALID" from per_all_people_f pap

922: IS
923: /* Cursor to retrieve Defined Balance Id */
924: CURSOR csr_check_person_number
925: IS
926: SELECT count('1') "VALID" from per_all_people_f pap
927: where pap.person_id=val_person_id
928: AND pap.EMPLOYEE_NUMBER=val_person_number
929: AND pap.EFFECTIVE_START_DATE <= g_income_end_date
930: AND pap.EFFECTIVE_END_DATE > = g_income_start_date

Line 1909: l_person_id per_all_people_f.person_id%TYPE;

1905: l_local_unit_id_fetched NUMBER;
1906: l_eit_local_unit NUMBER;
1907: l_legal_employer_id_fetched NUMBER;
1908: -- Temp needed Variables
1909: l_person_id per_all_people_f.person_id%TYPE;
1910: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1911:
1912: -- Temp needed Variables
1913:

Line 1966: FROM per_all_people_f pap

1962: ,ft.territory_code
1963: ,pap.effective_end_date
1964: ,pap.EMPLOYEE_NUMBER
1965: ,pap.date_of_birth -- EOY 2008/2009
1966: FROM per_all_people_f pap
1967: ,fnd_territories_vl ft
1968: WHERE pap.person_id = csr_v_person_id
1969: AND pap.per_information_category = 'SE'
1970: AND ft.obsolete_flag = 'N'

Line 1978: per_all_people_f pap

1974:
1975: /* SELECT pap.last_name, pap.pre_name_adjunct, pap.first_name
1976: , pap.national_identifier, pap.person_id
1977: FROM
1978: per_all_people_f pap
1979: WHERE pap.person_id = csr_v_person_id
1980: AND pap.per_information_category = 'SE'
1981: AND csr_v_effective_date BETWEEN pap.effective_start_date
1982: AND pap.effective_end_date;