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

Line 318: ,PER_ALL_PEOPLE_F pap

314: ,pap.SEX
315: FROM
316: PER_ALL_ASSIGNMENTS_F paa
317: ,HR_SOFT_CODING_KEYFLEX scl1
318: ,PER_ALL_PEOPLE_F pap
319: WHERE
320: paa.person_id = pap.person_id
321: and paa.business_group_id = g_business_group_id
322: and scl1.segment2 = TO_CHAR(csr_local_unit_ID)

Line 372: per_all_people_f papf,

368: /* To Get All the Persons, sex under the Local unit within the period */
369: CURSOR csr_person_local_unit(p_local_unit_id number) is
370: SELECT DISTINCT paaf.person_id,sex
371: FROM per_all_assignments_f paaf,
372: per_all_people_f papf,
373: hr_soft_coding_keyflex hsck
374: WHERE paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
375: AND hsck.segment2=to_char(p_local_unit_id)
376: AND papf.person_id=paaf.person_id

Line 443: per_all_people_f papf

439: /* To get the sex of the person, from the assignment */
440: CURSOR csr_person_sex(p_assignment_id number) IS
441: SELECT papf.sex FROM
442: per_all_assignments_f paaf,
443: per_all_people_f papf
444: WHERE paaf.person_id=papf.person_id
445: AND paaf.assignment_id=p_assignment_id
446: AND g_account_date BETWEEN paaf.effective_start_date
447: AND paaf.effective_end_date

Line 2272: ,PER_ALL_PEOPLE_F pap

2268: hr_all_organization_units hou_lu,
2269: hr_organization_information hoi_lu,
2270: PER_ALL_ASSIGNMENTS_F paa
2271: ,HR_SOFT_CODING_KEYFLEX scl1
2272: ,PER_ALL_PEOPLE_F pap
2273: WHERE
2274: hoi_le.organization_id = hou_le.organization_id
2275: AND hou_le.name =p_legal_employer
2276: AND hoi_le.org_information_context = 'SE_LOCAL_UNITS'