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.

[Home] [Help]

APPS.PAY_DK_ARCHIVE_EHOL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 749: from per_assignment_status_types

745: assignment_id = p_asg_id
746: AND EFFECTIVE_END_DATE > = p_start_date
747: AND assignment_status_type_id IN
748: (select assignment_status_type_id
749: from per_assignment_status_types
750: where per_system_status = 'ACTIVE_ASSIGN'
751: and active_flag = 'Y'
752: and (( legislation_code is null
753: and business_group_id is null)

Line 1373: from per_assignment_status_types

1369: -- AND paa.EFFECTIVE_START_DATE <= p_end_date 10322958
1370: AND paa.EFFECTIVE_END_DATE > = p_start_date
1371: AND assignment_status_type_id IN
1372: (select assignment_status_type_id
1373: from per_assignment_status_types
1374: where per_system_status = 'ACTIVE_ASSIGN'
1375: and active_flag = 'Y'
1376: and (( legislation_code is null
1377: and business_group_id is null)