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_ASSIGNMENTS_F

Line 483: FROM per_assignments_f ASG,

479: ASG.effective_end_date,
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

Line 1037: FROM per_assignments_f ASG,

1033: SELECT PYB.input_value_id,
1034: FCL.meaning
1035: INTO v_inpval_id,
1036: v_pay_basis
1037: FROM per_assignments_f ASG,
1038: per_pay_bases PYB,
1039: hr_lookups FCL
1040: WHERE FCL.lookup_code = PYB.pay_basis
1041: AND FCL.lookup_type = 'PAY_BASIS'

Line 1354: FROM per_assignments_f ASG,

1350: select 1 INTO l_asg_info_changes
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

Line 1427: FROM per_assignments_f ASG,

1423: select 1 INTO l_asg_info_changes
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

Line 1521: FROM per_assignments_f ASG,

1517: hr_utility.trace(' Check assignment status of current asg record');
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

Line 1592: FROM per_assignments_f ASG,

1588: v_range_end,
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

Line 1685: per_assignments_f ASG,

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
1689: AND ASG.effective_start_date > p_period_start

Line 1847: FROM per_assignments_f ASG,

1843: v_range_end,
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

Line 2070: per_assignments_f ASG,

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
2074: AND ASG.effective_start_date > p_period_start