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 493: per_assignment_status_types AST,

489: NVL(ASG.normal_hours, 0),
490: NVL(HRL.meaning, 'NOT ENTERED'),
491: NVL(SCL.segment4, 'NOT ENTERED')
492: FROM per_assignments_f ASG,
493: per_assignment_status_types AST,
494: hr_soft_coding_keyflex SCL,
495: hr_lookups HRL
496: WHERE ASG.assignment_id = p_asst_id
497: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1364: per_assignment_status_types AST,

1360: from dual
1361: where exists (
1362: SELECT 1
1363: FROM per_assignments_f ASG,
1364: per_assignment_status_types AST,
1365: hr_soft_coding_keyflex SCL
1366: WHERE ASG.assignment_id = p_asst_id
1367: AND ASG.effective_start_date <= p_period_start
1368: AND ASG.effective_end_date >= p_period_start

Line 1437: per_assignment_status_types AST,

1433: from dual
1434: where exists (
1435: SELECT 1
1436: FROM per_assignments_f ASG,
1437: per_assignment_status_types AST,
1438: hr_soft_coding_keyflex SCL
1439: WHERE ASG.assignment_id = p_asst_id
1440: AND ASG.effective_start_date > p_period_start
1441: AND ASG.effective_start_date <= p_period_end

Line 1531: per_assignment_status_types AST,

1527:
1528: SELECT AST.per_system_status
1529: INTO v_asg_status
1530: FROM per_assignments_f ASG,
1531: per_assignment_status_types AST,
1532: hr_soft_coding_keyflex SCL
1533: WHERE ASG.assignment_id = p_asst_id
1534: AND p_period_start BETWEEN ASG.effective_start_date
1535: AND ASG.effective_end_date

Line 1602: per_assignment_status_types AST,

1598: v_asst_std_hrs,
1599: v_asst_std_freq,
1600: v_work_schedule
1601: FROM per_assignments_f ASG,
1602: per_assignment_status_types AST,
1603: hr_soft_coding_keyflex SCL,
1604: hr_lookups HRL
1605: WHERE ASG.assignment_id = p_asst_id
1606: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1693: per_assignment_status_types AST,

1689: v_asst_std_hrs,
1690: v_asst_std_freq,
1691: v_work_schedule
1692: FROM hr_soft_coding_keyflex SCL,
1693: per_assignment_status_types AST,
1694: per_assignments_f ASG,
1695: hr_lookups HRL
1696: WHERE ASG.assignment_id = p_asst_id
1697: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1857: per_assignment_status_types AST,

1853: v_asst_std_hrs,
1854: v_asst_std_freq,
1855: v_work_schedule
1856: FROM per_assignments_f ASG,
1857: per_assignment_status_types AST,
1858: hr_soft_coding_keyflex SCL,
1859: hr_lookups HRL
1860: WHERE ASG.assignment_id = p_asst_id
1861: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 2078: per_assignment_status_types AST,

2074: v_asst_std_hrs,
2075: v_asst_std_freq,
2076: v_work_schedule
2077: FROM hr_soft_coding_keyflex SCL,
2078: per_assignment_status_types AST,
2079: per_assignments_f ASG,
2080: hr_lookups HRL
2081: WHERE ASG.assignment_id = p_asst_id
2082: AND ASG.business_group_id + 0 = p_bus_grp_id