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.HR_FI_VALIDATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1963: ,PER_ALL_ASSIGNMENTS_F paa

1959: SELECT hsc.segment12
1960: FROM HR_ORGANIZATION_UNITS o1
1961: ,HR_ORGANIZATION_INFORMATION hoi1
1962: ,HR_ORGANIZATION_INFORMATION hoi2
1963: ,PER_ALL_ASSIGNMENTS_F paa
1964: ,HR_SOFT_CODING_KEYFLEX hsc
1965: WHERE o1.business_group_id =l_business_group_id
1966: and o1.organization_id = hoi1.organization_id
1967: and hoi1.org_information_context = 'CLASS'

Line 2057: FROM per_all_assignments_f

2053:
2054: CURSOR getbgid
2055: IS
2056: SELECT business_group_id
2057: FROM per_all_assignments_f
2058: where assignment_id = p_assignment_id;
2059:
2060:
2061: CURSOR get_rpt_asg ( p_le NUMBER )

Line 2067: ,PER_ALL_ASSIGNMENTS_F paa

2063: SELECT hsc.segment12
2064: FROM HR_ORGANIZATION_UNITS o1
2065: ,HR_ORGANIZATION_INFORMATION hoi1
2066: ,HR_ORGANIZATION_INFORMATION hoi2
2067: ,PER_ALL_ASSIGNMENTS_F paa
2068: ,HR_SOFT_CODING_KEYFLEX hsc
2069: WHERE o1.business_group_id =l_business_group_id
2070: and o1.organization_id = hoi1.organization_id
2071: and hoi1.org_information_context = 'CLASS'

Line 2105: FROM per_all_assignments_f a

2101:
2102: CURSOR c_person
2103: IS
2104: SELECT person_id
2105: FROM per_all_assignments_f a
2106: WHERE a.assignment_id = p_assignment_id
2107: AND p_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;
2108:
2109: BEGIN