APPS.PAY_CORE_FF_UDFS dependencies on HR_SOFT_CODING_KEYFLEX

Line 154: hr_soft_coding_keyflex target,

150: p_date_earned date,
151: p_assignment_id number) IS
152: SELECT target.SEGMENT4
153: FROM /* route for SCL keyflex - assignment level */
154: hr_soft_coding_keyflex target,
155: per_all_assignments_f ASSIGN
156: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
157: AND ASSIGN.effective_end_date
158: AND ASSIGN.assignment_id = p_assignment_id

Line 1123: -- in HR_SOFT_CODING_KEYFLEX; convert

1119: v_entry_end DATE; -- end date of ELE ENTRY rec
1120: v_entrange_start DATE; -- max of entry or asst range start
1121: v_entrange_end DATE; -- min of entry or asst range end
1122: v_work_schedule VARCHAR2(60); -- Work Schedule ID (stored as varchar2
1123: -- in HR_SOFT_CODING_KEYFLEX; convert
1124: -- fnd_number.canonical_to_number when calling wshours fn.
1125: v_work_sched_name VARCHAR2(80);
1126: v_ws_id NUMBER(9);
1127:

Line 1169: hr_soft_coding_keyflex SCL,

1165: NVL(HRL.meaning, 'NOT ENTERED'),
1166: NVL(SCL.segment4, 'NOT ENTERED')
1167: FROM per_assignments_f ASG,
1168: per_assignment_status_types AST,
1169: hr_soft_coding_keyflex SCL,
1170: hr_lookups HRL
1171: WHERE ASG.assignment_id = p_asst_id
1172: AND ASG.business_group_id + 0 = p_bus_grp_id
1173: AND ASG.effective_start_date > p_period_start

Line 2137: hr_soft_coding_keyflex SCL

2133: where exists (
2134: SELECT 1
2135: FROM per_assignments_f ASG,
2136: per_assignment_status_types AST,
2137: hr_soft_coding_keyflex SCL
2138: WHERE ASG.assignment_id = p_asst_id
2139: AND ASG.effective_start_date <= p_period_start
2140: AND ASG.effective_end_date >= p_period_start
2141: AND ASG.effective_end_date < p_period_end

Line 2210: hr_soft_coding_keyflex SCL

2206: where exists (
2207: SELECT 1
2208: FROM per_assignments_f ASG,
2209: per_assignment_status_types AST,
2210: hr_soft_coding_keyflex SCL
2211: WHERE ASG.assignment_id = p_asst_id
2212: AND ASG.effective_start_date > p_period_start
2213: AND ASG.effective_start_date <= p_period_end
2214: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 2332: hr_soft_coding_keyflex SCL

2328: SELECT AST.per_system_status
2329: INTO v_asg_status
2330: FROM per_assignments_f ASG,
2331: per_assignment_status_types AST,
2332: hr_soft_coding_keyflex SCL
2333: WHERE ASG.assignment_id = p_asst_id
2334: AND p_period_start BETWEEN ASG.effective_start_date
2335: AND ASG.effective_end_date
2336: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 2405: hr_soft_coding_keyflex SCL,

2401: v_asst_std_freq,
2402: v_work_schedule
2403: FROM per_assignments_f ASG,
2404: per_assignment_status_types AST,
2405: hr_soft_coding_keyflex SCL,
2406: hr_lookups HRL
2407: WHERE ASG.assignment_id = p_asst_id
2408: AND ASG.business_group_id + 0 = p_bus_grp_id
2409: AND ASG.effective_start_date <= p_period_start

Line 2488: FROM hr_soft_coding_keyflex SCL,

2484: v_range_end,
2485: v_asst_std_hrs,
2486: v_asst_std_freq,
2487: v_work_schedule
2488: FROM hr_soft_coding_keyflex SCL,
2489: per_assignment_status_types AST,
2490: per_assignments_f ASG,
2491: hr_lookups HRL
2492: WHERE ASG.assignment_id = p_asst_id

Line 2648: hr_soft_coding_keyflex SCL,

2644: v_asst_std_freq,
2645: v_work_schedule
2646: FROM per_assignments_f ASG,
2647: per_assignment_status_types AST,
2648: hr_soft_coding_keyflex SCL,
2649: hr_lookups HRL
2650: WHERE ASG.assignment_id = p_asst_id
2651: AND ASG.business_group_id + 0 = p_bus_grp_id
2652: AND ASG.effective_start_date <= p_period_start

Line 2888: FROM hr_soft_coding_keyflex SCL,

2884: v_range_end,
2885: v_asst_std_hrs,
2886: v_asst_std_freq,
2887: v_work_schedule
2888: FROM hr_soft_coding_keyflex SCL,
2889: per_assignment_status_types AST,
2890: per_assignments_f ASG,
2891: hr_lookups HRL
2892: WHERE ASG.assignment_id = p_asst_id