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 170: -- in HR_SOFT_CODING_KEYFLEX; convert

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

Line 218: hr_soft_coding_keyflex SCL,

214: NVL(HRL.lookup_code, 'NOT ENTERED'),
215: NVL(SCL.segment4, 'NOT ENTERED')
216: FROM per_assignments_f ASG,
217: per_assignment_status_types AST,
218: hr_soft_coding_keyflex SCL,
219: hr_lookups HRL
220: WHERE ASG.assignment_id = p_asst_id
221: AND ASG.business_group_id + 0 = p_bus_grp_id
222: AND ASG.effective_start_date > p_period_start

Line 992: hr_soft_coding_keyflex SCL

988: where exists (
989: SELECT 1
990: FROM per_assignments_f ASG,
991: per_assignment_status_types AST,
992: hr_soft_coding_keyflex SCL
993: WHERE ASG.assignment_id = p_asst_id
994: AND ASG.effective_start_date <= p_period_start
995: AND ASG.effective_end_date >= p_period_start
996: AND ASG.effective_end_date < p_period_end

Line 1072: hr_soft_coding_keyflex SCL

1068: where exists (
1069: SELECT 1
1070: FROM per_assignments_f ASG,
1071: per_assignment_status_types AST,
1072: hr_soft_coding_keyflex SCL
1073: WHERE ASG.assignment_id = p_asst_id
1074: AND ASG.effective_start_date > p_period_start
1075: AND ASG.effective_start_date <= p_period_end
1076: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 1166: hr_soft_coding_keyflex SCL

1162: SELECT AST.per_system_status
1163: INTO v_asg_status
1164: FROM per_assignments_f ASG,
1165: per_assignment_status_types AST,
1166: hr_soft_coding_keyflex SCL
1167: WHERE ASG.assignment_id = p_asst_id
1168: AND p_period_start BETWEEN ASG.effective_start_date
1169: AND ASG.effective_end_date
1170: AND AST.assignment_status_type_id = ASG.assignment_status_type_id

Line 1269: hr_soft_coding_keyflex SCL,

1265: v_asst_std_freq_code,
1266: v_work_schedule
1267: FROM per_assignments_f ASG,
1268: per_assignment_status_types AST,
1269: hr_soft_coding_keyflex SCL,
1270: hr_lookups HRL
1271: WHERE ASG.assignment_id = p_asst_id
1272: AND ASG.business_group_id + 0 = p_bus_grp_id
1273: AND ASG.effective_start_date <= p_period_start

Line 1385: FROM hr_soft_coding_keyflex SCL,

1381: v_asst_std_hrs,
1382: v_asst_std_freq,
1383: v_asst_std_freq_code,
1384: v_work_schedule
1385: FROM hr_soft_coding_keyflex SCL,
1386: per_assignment_status_types AST,
1387: per_assignments_f ASG,
1388: hr_lookups HRL
1389: WHERE ASG.assignment_id = p_asst_id

Line 1522: hr_soft_coding_keyflex SCL,

1518: v_asst_std_freq_code,
1519: v_work_schedule
1520: FROM per_assignments_f ASG,
1521: per_assignment_status_types AST,
1522: hr_soft_coding_keyflex SCL,
1523: hr_lookups HRL
1524: WHERE ASG.assignment_id = p_asst_id
1525: AND ASG.business_group_id + 0 = p_bus_grp_id
1526: AND ASG.effective_start_date <= p_period_start

Line 1774: FROM hr_soft_coding_keyflex SCL,

1770: v_asst_std_hrs,
1771: v_asst_std_freq,
1772: v_asst_std_freq_code,
1773: v_work_schedule
1774: FROM hr_soft_coding_keyflex SCL,
1775: per_assignment_status_types AST,
1776: per_assignments_f ASG,
1777: hr_lookups HRL
1778: WHERE ASG.assignment_id = p_asst_id