APPS.HR_US_FF_UDFS dependencies on HR_SOFT_CODING_KEYFLEX

Line 445: -- in HR_SOFT_CODING_KEYFLEX; convert

441: v_entry_end DATE; -- end date of ELE ENTRY rec
442: v_entrange_start DATE; -- max of entry or asst range start
443: v_entrange_end DATE; -- min of entry or asst range end
444: v_work_schedule VARCHAR2(60); -- Work Schedule ID (stored as varchar2
445: -- in HR_SOFT_CODING_KEYFLEX; convert
446: -- fnd_number.canonical_to_number when calling wshours fn.
447: v_work_sched_name VARCHAR2(80);
448: v_ws_id NUMBER(9);
449:

Line 485: hr_soft_coding_keyflex SCL,

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

Line 1356: hr_soft_coding_keyflex SCL

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
1360: AND ASG.effective_end_date < p_period_end

Line 1429: hr_soft_coding_keyflex SCL

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
1433: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 1523: hr_soft_coding_keyflex SCL

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
1527: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 1594: hr_soft_coding_keyflex SCL,

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

Line 1683: FROM hr_soft_coding_keyflex SCL,

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

Line 1849: hr_soft_coding_keyflex SCL,

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

Line 2068: FROM hr_soft_coding_keyflex SCL,

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