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

Line 223: per_assignment_status_types AST,

219: NVL(HRL.meaning, 'NOT ENTERED'),
220: NVL(HRL.lookup_code, 'NOT ENTERED'),
221: NVL(SCL.segment4, 'NOT ENTERED')
222: FROM per_assignments_f ASG,
223: per_assignment_status_types AST,
224: hr_soft_coding_keyflex SCL,
225: hr_lookups HRL
226: WHERE ASG.assignment_id = p_asst_id
227: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 997: per_assignment_status_types AST,

993: from dual
994: where exists (
995: SELECT 1
996: FROM per_assignments_f ASG,
997: per_assignment_status_types AST,
998: hr_soft_coding_keyflex SCL
999: WHERE ASG.assignment_id = p_asst_id
1000: AND ASG.effective_start_date <= p_period_start
1001: AND ASG.effective_end_date >= p_period_start

Line 1077: per_assignment_status_types AST,

1073: from dual
1074: where exists (
1075: SELECT 1
1076: FROM per_assignments_f ASG,
1077: per_assignment_status_types AST,
1078: hr_soft_coding_keyflex SCL
1079: WHERE ASG.assignment_id = p_asst_id
1080: AND ASG.effective_start_date > p_period_start
1081: AND ASG.effective_start_date <= p_period_end

Line 1200: per_assignment_status_types AST,

1196:
1197: SELECT AST.per_system_status
1198: INTO v_asg_status
1199: FROM per_assignments_f ASG,
1200: per_assignment_status_types AST,
1201: hr_soft_coding_keyflex SCL
1202: WHERE ASG.assignment_id = p_asst_id
1203: AND p_period_start BETWEEN ASG.effective_start_date
1204: AND ASG.effective_end_date

Line 1305: per_assignment_status_types AST,

1301: v_asst_std_freq,
1302: v_asst_std_freq_code,
1303: v_work_schedule
1304: FROM per_assignments_f ASG,
1305: per_assignment_status_types AST,
1306: hr_soft_coding_keyflex SCL,
1307: hr_lookups HRL
1308: WHERE ASG.assignment_id = p_asst_id
1309: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1423: per_assignment_status_types AST,

1419: v_asst_std_freq,
1420: v_asst_std_freq_code,
1421: v_work_schedule
1422: FROM hr_soft_coding_keyflex SCL,
1423: per_assignment_status_types AST,
1424: per_assignments_f ASG,
1425: hr_lookups HRL
1426: WHERE ASG.assignment_id = p_asst_id
1427: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1558: per_assignment_status_types AST,

1554: v_asst_std_freq,
1555: v_asst_std_freq_code,
1556: v_work_schedule
1557: FROM per_assignments_f ASG,
1558: per_assignment_status_types AST,
1559: hr_soft_coding_keyflex SCL,
1560: hr_lookups HRL
1561: WHERE ASG.assignment_id = p_asst_id
1562: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1812: per_assignment_status_types AST,

1808: v_asst_std_freq,
1809: v_asst_std_freq_code,
1810: v_work_schedule
1811: FROM hr_soft_coding_keyflex SCL,
1812: per_assignment_status_types AST,
1813: per_assignments_f ASG,
1814: hr_lookups HRL
1815: WHERE ASG.assignment_id = p_asst_id
1816: AND ASG.business_group_id + 0 = p_bus_grp_id