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_ASSIGNMENT_STATUS_TYPES

Line 969: FROM per_assignment_status_types

965: AND paa.effective_end_date > = g_income_start_date
966: AND paa.primary_flag = 'Y'
967: AND paa.assignment_status_type_id IN (
968: SELECT assignment_status_type_id
969: FROM per_assignment_status_types
970: WHERE per_system_status = 'ACTIVE_ASSIGN'
971: AND active_flag = 'Y'
972: AND ( ( legislation_code IS NULL
973: AND business_group_id IS NULL

Line 1934: FROM per_assignment_status_types

1930: AND paa.effective_start_date <= g_income_end_date
1931: AND paa.effective_end_date > = g_income_start_date
1932: AND assignment_status_type_id IN (
1933: SELECT assignment_status_type_id
1934: FROM per_assignment_status_types
1935: WHERE per_system_status = 'ACTIVE_ASSIGN'
1936: AND active_flag = 'Y'
1937: AND ( ( legislation_code IS NULL
1938: AND business_group_id IS NULL

Line 2025: FROM per_assignment_status_types

2021: AND paa.effective_start_date <= g_income_end_date
2022: AND paa.effective_end_date > = g_income_start_date
2023: AND assignment_status_type_id IN (
2024: SELECT assignment_status_type_id
2025: FROM per_assignment_status_types
2026: WHERE per_system_status = 'ACTIVE_ASSIGN'
2027: AND active_flag = 'Y'
2028: AND ( ( legislation_code IS NULL
2029: AND business_group_id IS NULL

Line 2136: FROM per_assignment_status_types

2132: AND paa.effective_start_date <= g_income_end_date
2133: AND paa.effective_end_date > = g_income_start_date
2134: AND paa.assignment_status_type_id IN (
2135: SELECT assignment_status_type_id
2136: FROM per_assignment_status_types
2137: WHERE per_system_status = 'ACTIVE_ASSIGN'
2138: AND active_flag = 'Y'
2139: AND ( ( legislation_code IS NULL
2140: AND business_group_id IS NULL

Line 2162: FROM per_assignment_status_types

2158: AND paa.effective_end_date > = g_income_start_date
2159: AND paa.primary_flag = 'Y'
2160: AND paa.assignment_status_type_id IN (
2161: SELECT assignment_status_type_id
2162: FROM per_assignment_status_types
2163: WHERE per_system_status = 'ACTIVE_ASSIGN'
2164: AND active_flag = 'Y'
2165: AND ( ( legislation_code IS NULL
2166: AND business_group_id IS NULL

Line 2267: from per_assignment_status_types

2263: AND pee.EFFECTIVE_START_DATE <= g_income_end_date AND pee.EFFECTIVE_END_DATE > = g_income_start_date
2264: AND paa.EFFECTIVE_START_DATE <= g_income_end_date AND paa.EFFECTIVE_END_DATE > = g_income_start_date
2265: AND paa.assignment_status_type_id IN
2266: (select assignment_status_type_id
2267: from per_assignment_status_types
2268: where per_system_status = 'ACTIVE_ASSIGN'
2269: and active_flag = 'Y'
2270: and (
2271: ( legislation_code is null