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 963: FROM per_assignment_status_types

959: AND paa.effective_end_date > = g_income_start_date
960: AND paa.primary_flag = 'Y'
961: AND paa.assignment_status_type_id IN (
962: SELECT assignment_status_type_id
963: FROM per_assignment_status_types
964: WHERE per_system_status = 'ACTIVE_ASSIGN'
965: AND active_flag = 'Y'
966: AND ( ( legislation_code IS NULL
967: AND business_group_id IS NULL

Line 1920: FROM per_assignment_status_types

1916: AND paa.effective_start_date <= g_income_end_date
1917: AND paa.effective_end_date > = g_income_start_date
1918: AND assignment_status_type_id IN (
1919: SELECT assignment_status_type_id
1920: FROM per_assignment_status_types
1921: WHERE per_system_status = 'ACTIVE_ASSIGN'
1922: AND active_flag = 'Y'
1923: AND ( ( legislation_code IS NULL
1924: AND business_group_id IS NULL

Line 2010: FROM per_assignment_status_types

2006: AND paa.effective_start_date <= g_income_end_date
2007: AND paa.effective_end_date > = g_income_start_date
2008: AND assignment_status_type_id IN (
2009: SELECT assignment_status_type_id
2010: FROM per_assignment_status_types
2011: WHERE per_system_status = 'ACTIVE_ASSIGN'
2012: AND active_flag = 'Y'
2013: AND ( ( legislation_code IS NULL
2014: AND business_group_id IS NULL

Line 2121: FROM per_assignment_status_types

2117: AND paa.effective_start_date <= g_income_end_date
2118: AND paa.effective_end_date > = g_income_start_date
2119: AND paa.assignment_status_type_id IN (
2120: SELECT assignment_status_type_id
2121: FROM per_assignment_status_types
2122: WHERE per_system_status = 'ACTIVE_ASSIGN'
2123: AND active_flag = 'Y'
2124: AND ( ( legislation_code IS NULL
2125: AND business_group_id IS NULL

Line 2147: FROM per_assignment_status_types

2143: AND paa.effective_end_date > = g_income_start_date
2144: AND paa.primary_flag = 'Y'
2145: AND paa.assignment_status_type_id IN (
2146: SELECT assignment_status_type_id
2147: FROM per_assignment_status_types
2148: WHERE per_system_status = 'ACTIVE_ASSIGN'
2149: AND active_flag = 'Y'
2150: AND ( ( legislation_code IS NULL
2151: AND business_group_id IS NULL

Line 2252: from per_assignment_status_types

2248: AND pee.EFFECTIVE_START_DATE <= g_income_end_date AND pee.EFFECTIVE_END_DATE > = g_income_start_date
2249: AND paa.EFFECTIVE_START_DATE <= g_income_end_date AND paa.EFFECTIVE_END_DATE > = g_income_start_date
2250: AND paa.assignment_status_type_id IN
2251: (select assignment_status_type_id
2252: from per_assignment_status_types
2253: where per_system_status = 'ACTIVE_ASSIGN'
2254: and active_flag = 'Y'
2255: and (
2256: ( legislation_code is null