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

Line 484: per_assignment_status_types AST,

480: NVL(ASG.normal_hours, 0),
481: NVL(HRL.meaning, 'NOT ENTERED'),
482: NVL(SCL.segment4, 'NOT ENTERED')
483: FROM per_assignments_f ASG,
484: per_assignment_status_types AST,
485: hr_soft_coding_keyflex SCL,
486: hr_lookups HRL
487: WHERE ASG.assignment_id = p_asst_id
488: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1355: per_assignment_status_types AST,

1351: from dual
1352: where exists (
1353: SELECT 1
1354: FROM per_assignments_f ASG,
1355: per_assignment_status_types AST,
1356: hr_soft_coding_keyflex SCL
1357: WHERE ASG.assignment_id = p_asst_id
1358: AND ASG.effective_start_date <= p_period_start
1359: AND ASG.effective_end_date >= p_period_start

Line 1428: per_assignment_status_types AST,

1424: from dual
1425: where exists (
1426: SELECT 1
1427: FROM per_assignments_f ASG,
1428: per_assignment_status_types AST,
1429: hr_soft_coding_keyflex SCL
1430: WHERE ASG.assignment_id = p_asst_id
1431: AND ASG.effective_start_date > p_period_start
1432: AND ASG.effective_start_date <= p_period_end

Line 1522: per_assignment_status_types AST,

1518:
1519: SELECT AST.per_system_status
1520: INTO v_asg_status
1521: FROM per_assignments_f ASG,
1522: per_assignment_status_types AST,
1523: hr_soft_coding_keyflex SCL
1524: WHERE ASG.assignment_id = p_asst_id
1525: AND p_period_start BETWEEN ASG.effective_start_date
1526: AND ASG.effective_end_date

Line 1593: per_assignment_status_types AST,

1589: v_asst_std_hrs,
1590: v_asst_std_freq,
1591: v_work_schedule
1592: FROM per_assignments_f ASG,
1593: per_assignment_status_types AST,
1594: hr_soft_coding_keyflex SCL,
1595: hr_lookups HRL
1596: WHERE ASG.assignment_id = p_asst_id
1597: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1684: per_assignment_status_types AST,

1680: v_asst_std_hrs,
1681: v_asst_std_freq,
1682: v_work_schedule
1683: FROM hr_soft_coding_keyflex SCL,
1684: per_assignment_status_types AST,
1685: per_assignments_f ASG,
1686: hr_lookups HRL
1687: WHERE ASG.assignment_id = p_asst_id
1688: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1848: per_assignment_status_types AST,

1844: v_asst_std_hrs,
1845: v_asst_std_freq,
1846: v_work_schedule
1847: FROM per_assignments_f ASG,
1848: per_assignment_status_types AST,
1849: hr_soft_coding_keyflex SCL,
1850: hr_lookups HRL
1851: WHERE ASG.assignment_id = p_asst_id
1852: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 2069: per_assignment_status_types AST,

2065: v_asst_std_hrs,
2066: v_asst_std_freq,
2067: v_work_schedule
2068: FROM hr_soft_coding_keyflex SCL,
2069: per_assignment_status_types AST,
2070: per_assignments_f ASG,
2071: hr_lookups HRL
2072: WHERE ASG.assignment_id = p_asst_id
2073: AND ASG.business_group_id + 0 = p_bus_grp_id