APPS.HR_CA_FF_UDFS dependencies on HR_SOFT_CODING_KEYFLEX

Line 33: hr_soft_coding_keyflex table

29: instead.
30: 10-Jan-2002 vpandya Converted p_tax_unit_id to
31: character while comparing it
32: to segment1 in
33: hr_soft_coding_keyflex table
34: to overcome 'invali number' &
35: also added dbdrv lines for gscc
36: 30-OCT-2002 pganguly 2647412 Changed Convert_Period_Type.
37: Previously it used to get the

Line 67: hr_soft_coding_keyflex

63: 22-Jan-2003 vpandya 115.10 For Multi GRE functionality,
64: tax unit id will be stored in
65: segment1, segment11 and
66: segment12 of
67: hr_soft_coding_keyflex
68: depending on the gre type.
69: Changed all conditions wherever
70: segment1 is used for tax unit
71: id.

Line 174: -- in HR_SOFT_CODING_KEYFLEX; convert

170: v_entry_end DATE; -- end date of ELE ENTRY rec
171: v_entrange_start DATE; -- max of entry or asst range start
172: v_entrange_end DATE; -- min of entry or asst range end
173: v_work_schedule VARCHAR2(60); -- Work Schedule ID (stored as varchar2
174: -- in HR_SOFT_CODING_KEYFLEX; convert
175: -- to_number when calling wshours fn.
176: v_work_sched_name VARCHAR2(80);
177: v_ws_id NUMBER(9);
178:

Line 224: hr_soft_coding_keyflex SCL,

220: NVL(HRL.lookup_code, 'NOT ENTERED'),
221: NVL(SCL.segment4, 'NOT ENTERED')
222: FROM per_assignments_f ASG,
223: per_assignment_status_types AST,
224: hr_soft_coding_keyflex SCL,
225: hr_lookups HRL
226: WHERE ASG.assignment_id = p_asst_id
227: AND ASG.business_group_id + 0 = p_bus_grp_id
228: AND ASG.effective_start_date > p_period_start

Line 998: hr_soft_coding_keyflex SCL

994: where exists (
995: SELECT 1
996: FROM per_assignments_f ASG,
997: per_assignment_status_types AST,
998: hr_soft_coding_keyflex SCL
999: WHERE ASG.assignment_id = p_asst_id
1000: AND ASG.effective_start_date <= p_period_start
1001: AND ASG.effective_end_date >= p_period_start
1002: AND ASG.effective_end_date < p_period_end

Line 1078: hr_soft_coding_keyflex SCL

1074: where exists (
1075: SELECT 1
1076: FROM per_assignments_f ASG,
1077: per_assignment_status_types AST,
1078: hr_soft_coding_keyflex SCL
1079: WHERE ASG.assignment_id = p_asst_id
1080: AND ASG.effective_start_date > p_period_start
1081: AND ASG.effective_start_date <= p_period_end
1082: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 1201: hr_soft_coding_keyflex SCL

1197: SELECT AST.per_system_status
1198: INTO v_asg_status
1199: FROM per_assignments_f ASG,
1200: per_assignment_status_types AST,
1201: hr_soft_coding_keyflex SCL
1202: WHERE ASG.assignment_id = p_asst_id
1203: AND p_period_start BETWEEN ASG.effective_start_date
1204: AND ASG.effective_end_date
1205: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 1306: hr_soft_coding_keyflex SCL,

1302: v_asst_std_freq_code,
1303: v_work_schedule
1304: FROM per_assignments_f ASG,
1305: per_assignment_status_types AST,
1306: hr_soft_coding_keyflex SCL,
1307: hr_lookups HRL
1308: WHERE ASG.assignment_id = p_asst_id
1309: AND ASG.business_group_id + 0 = p_bus_grp_id
1310: AND ASG.effective_start_date <= p_period_start

Line 1422: FROM hr_soft_coding_keyflex SCL,

1418: v_asst_std_hrs,
1419: v_asst_std_freq,
1420: v_asst_std_freq_code,
1421: v_work_schedule
1422: FROM hr_soft_coding_keyflex SCL,
1423: per_assignment_status_types AST,
1424: per_assignments_f ASG,
1425: hr_lookups HRL
1426: WHERE ASG.assignment_id = p_asst_id

Line 1559: hr_soft_coding_keyflex SCL,

1555: v_asst_std_freq_code,
1556: v_work_schedule
1557: FROM per_assignments_f ASG,
1558: per_assignment_status_types AST,
1559: hr_soft_coding_keyflex SCL,
1560: hr_lookups HRL
1561: WHERE ASG.assignment_id = p_asst_id
1562: AND ASG.business_group_id + 0 = p_bus_grp_id
1563: AND ASG.effective_start_date <= p_period_start

Line 1811: FROM hr_soft_coding_keyflex SCL,

1807: v_asst_std_hrs,
1808: v_asst_std_freq,
1809: v_asst_std_freq_code,
1810: v_work_schedule
1811: FROM hr_soft_coding_keyflex SCL,
1812: per_assignment_status_types AST,
1813: per_assignments_f ASG,
1814: hr_lookups HRL
1815: WHERE ASG.assignment_id = p_asst_id