APPS.HR_US_FF_UDFS dependencies on PER_ASSIGNMENTS_F

Line 492: FROM per_assignments_f ASG,

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

Line 1046: FROM per_assignments_f ASG,

1042: SELECT PYB.input_value_id,
1043: FCL.meaning
1044: INTO v_inpval_id,
1045: v_pay_basis
1046: FROM per_assignments_f ASG,
1047: per_pay_bases PYB,
1048: hr_lookups FCL
1049: WHERE FCL.lookup_code = PYB.pay_basis
1050: AND FCL.lookup_type = 'PAY_BASIS'

Line 1363: FROM per_assignments_f ASG,

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

Line 1436: FROM per_assignments_f ASG,

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

Line 1530: FROM per_assignments_f ASG,

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

Line 1601: FROM per_assignments_f ASG,

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

Line 1694: per_assignments_f ASG,

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

Line 1856: FROM per_assignments_f ASG,

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

Line 2079: per_assignments_f ASG,

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