APPS.PAY_CORE_FF_UDFS dependencies on HR_SOFT_CODING_KEYFLEX

Line 744: -- in HR_SOFT_CODING_KEYFLEX; convert

740: v_entry_end DATE; -- end date of ELE ENTRY rec
741: v_entrange_start DATE; -- max of entry or asst range start
742: v_entrange_end DATE; -- min of entry or asst range end
743: v_work_schedule VARCHAR2(60); -- Work Schedule ID (stored as varchar2
744: -- in HR_SOFT_CODING_KEYFLEX; convert
745: -- fnd_number.canonical_to_number when calling wshours fn.
746: v_work_sched_name VARCHAR2(80);
747: v_ws_id NUMBER(9);
748:

Line 790: hr_soft_coding_keyflex SCL,

786: NVL(HRL.meaning, 'NOT ENTERED'),
787: NVL(SCL.segment4, 'NOT ENTERED')
788: FROM per_assignments_f ASG,
789: per_assignment_status_types AST,
790: hr_soft_coding_keyflex SCL,
791: hr_lookups HRL
792: WHERE ASG.assignment_id = p_asst_id
793: AND ASG.business_group_id + 0 = p_bus_grp_id
794: AND ASG.effective_start_date > p_period_start

Line 1758: hr_soft_coding_keyflex SCL

1754: where exists (
1755: SELECT 1
1756: FROM per_assignments_f ASG,
1757: per_assignment_status_types AST,
1758: hr_soft_coding_keyflex SCL
1759: WHERE ASG.assignment_id = p_asst_id
1760: AND ASG.effective_start_date <= p_period_start
1761: AND ASG.effective_end_date >= p_period_start
1762: AND ASG.effective_end_date < p_period_end

Line 1831: hr_soft_coding_keyflex SCL

1827: where exists (
1828: SELECT 1
1829: FROM per_assignments_f ASG,
1830: per_assignment_status_types AST,
1831: hr_soft_coding_keyflex SCL
1832: WHERE ASG.assignment_id = p_asst_id
1833: AND ASG.effective_start_date > p_period_start
1834: AND ASG.effective_start_date <= p_period_end
1835: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 1925: hr_soft_coding_keyflex SCL

1921: SELECT AST.per_system_status
1922: INTO v_asg_status
1923: FROM per_assignments_f ASG,
1924: per_assignment_status_types AST,
1925: hr_soft_coding_keyflex SCL
1926: WHERE ASG.assignment_id = p_asst_id
1927: AND p_period_start BETWEEN ASG.effective_start_date
1928: AND ASG.effective_end_date
1929: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 1996: hr_soft_coding_keyflex SCL,

1992: v_asst_std_freq,
1993: v_work_schedule
1994: FROM per_assignments_f ASG,
1995: per_assignment_status_types AST,
1996: hr_soft_coding_keyflex SCL,
1997: hr_lookups HRL
1998: WHERE ASG.assignment_id = p_asst_id
1999: AND ASG.business_group_id + 0 = p_bus_grp_id
2000: AND ASG.effective_start_date <= p_period_start

Line 2079: FROM hr_soft_coding_keyflex SCL,

2075: v_range_end,
2076: v_asst_std_hrs,
2077: v_asst_std_freq,
2078: v_work_schedule
2079: FROM hr_soft_coding_keyflex SCL,
2080: per_assignment_status_types AST,
2081: per_assignments_f ASG,
2082: hr_lookups HRL
2083: WHERE ASG.assignment_id = p_asst_id

Line 2239: hr_soft_coding_keyflex SCL,

2235: v_asst_std_freq,
2236: v_work_schedule
2237: FROM per_assignments_f ASG,
2238: per_assignment_status_types AST,
2239: hr_soft_coding_keyflex SCL,
2240: hr_lookups HRL
2241: WHERE ASG.assignment_id = p_asst_id
2242: AND ASG.business_group_id + 0 = p_bus_grp_id
2243: AND ASG.effective_start_date <= p_period_start

Line 2479: FROM hr_soft_coding_keyflex SCL,

2475: v_range_end,
2476: v_asst_std_hrs,
2477: v_asst_std_freq,
2478: v_work_schedule
2479: FROM hr_soft_coding_keyflex SCL,
2480: per_assignment_status_types AST,
2481: per_assignments_f ASG,
2482: hr_lookups HRL
2483: WHERE ASG.assignment_id = p_asst_id