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_SG_IRAS_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 3064: per_assignment_status_types sta

3060: select min(assign.effective_start_date),
3061: max(assign.effective_start_date)
3062: from per_assignments_f assign,
3063: hr_soft_coding_keyflex hsc,
3064: per_assignment_status_types sta
3065: where assign.person_id = c_person_id
3066: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3067: and hsc.segment1 = c_legal_entity_id
3068: and assign.assignment_type = 'E'

Line 3083: per_assignment_status_types sta

3079: is
3080: select 'Y'
3081: from per_assignments_f assign,
3082: hr_soft_coding_keyflex hsc,
3083: per_assignment_status_types sta
3084: where assign.person_id = c_person_id
3085: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3086: and hsc.segment1 = c_legal_entity_id
3087: and assign.assignment_type = 'E'

Line 3102: per_assignment_status_types sta

3098: select min(assign.effective_end_date),
3099: max(assign.effective_end_date)
3100: from per_assignments_f assign,
3101: hr_soft_coding_keyflex hsc,
3102: per_assignment_status_types sta
3103: where assign.person_id = c_person_id
3104: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3105: and hsc.segment1 = c_legal_entity_id
3106: and assign.assignment_type = 'E'