APPS.HR_INPUT_VALUES dependencies on PAY_INPUT_VALUES_F

Line 61: from pay_input_values_f iv

57: begin
58: --
59: select count(distinct iv.input_value_id)
60: into v_num_input_values
61: from pay_input_values_f iv
62: where iv.element_type_id = p_element_type_id
63: and p_val_start_date between
64: iv.effective_start_date and iv.effective_end_date;
65: --

Line 118: from pay_input_values_f_tl ipv_tl,

114: into v_validation_check
115: from sys.dual
116: where exists
117: (select 1
118: from pay_input_values_f_tl ipv_tl,
119: pay_input_values_f ipv
120: where ipv_tl.input_value_id = ipv.input_value_id
121: and userenv('LANG') = ipv_tl.language
122: and ipv.element_type_id = p_element_type_id

Line 119: pay_input_values_f ipv

115: from sys.dual
116: where exists
117: (select 1
118: from pay_input_values_f_tl ipv_tl,
119: pay_input_values_f ipv
120: where ipv_tl.input_value_id = ipv.input_value_id
121: and userenv('LANG') = ipv_tl.language
122: and ipv.element_type_id = p_element_type_id
123: and ipv.input_value_id <> p_input_value_id

Line 390: from pay_input_values_f iv

386: into l_min_value_missing
387: from sys.dual
388: where exists
389: (select 1
390: from pay_input_values_f iv
391: where p_input_value_id = iv.input_value_id
392: and iv.min_value is null
393: and iv.effective_start_date <= p_val_end_date
394: and iv.effective_end_date >= p_val_start_date);

Line 414: from pay_input_values_f iv

410: into l_max_value_missing
411: from sys.dual
412: where exists
413: (select 1
414: from pay_input_values_f iv
415: where p_input_value_id = iv.input_value_id
416: and iv.max_value is null
417: and iv.effective_start_date <= p_val_end_date
418: and iv.effective_end_date >= p_val_start_date);

Line 443: from pay_input_values_f iv

439: into l_default_value_missing
440: from sys.dual
441: where exists
442: (select 1
443: from pay_input_values_f iv
444: where p_input_value_id = iv.input_value_id
445: and iv.default_value is null
446: and iv.effective_start_date <= p_val_end_date
447: and iv.effective_end_date >= p_val_start_date);

Line 620: pay_input_values_f_tl ip_tl,

616: from sys.dual
617: where exists
618: (select 1
619: from pay_element_links_f el,
620: pay_input_values_f_tl ip_tl,
621: pay_input_values_f ip
622: where ip_tl.input_value_id = ip.input_value_id
623: and ip.input_value_id = p_input_value_id
624: and userenv('LANG') = ip_tl.language

Line 621: pay_input_values_f ip

617: where exists
618: (select 1
619: from pay_element_links_f el,
620: pay_input_values_f_tl ip_tl,
621: pay_input_values_f ip
622: where ip_tl.input_value_id = ip.input_value_id
623: and ip.input_value_id = p_input_value_id
624: and userenv('LANG') = ip_tl.language
625: and ip_tl.name = l_pay_value_name

Line 946: from pay_input_values_f iv

942: into l_validation_check
943: from sys.dual
944: where exists
945: (select 1
946: from pay_input_values_f iv
947: where iv.input_value_id = p_input_value_id
948: and iv.effective_start_date > p_val_start_date
949: and iv.mandatory_flag = 'Y');
950: --

Line 1085: from pay_input_values_f iv

1081: --
1082: -- This selects all input values for an element type
1083: cursor c_input_value(p_element_type_id number) is
1084: select iv.input_value_id input_value_id
1085: from pay_input_values_f iv
1086: where iv.element_type_id = p_element_type_id
1087: order by iv.input_value_id
1088: for update;
1089: --

Line 1145: from pay_input_values_f_tl iv_tl,

1141: -1,
1142: -1,
1143: -1,
1144: sysdate
1145: from pay_input_values_f_tl iv_tl,
1146: pay_input_values_f iv
1147: where iv_tl.input_value_id = iv.input_value_id
1148: and iv.input_value_id = iv_rec.input_value_id
1149: and userenv('LANG') = iv_tl.language

Line 1146: pay_input_values_f iv

1142: -1,
1143: -1,
1144: sysdate
1145: from pay_input_values_f_tl iv_tl,
1146: pay_input_values_f iv
1147: where iv_tl.input_value_id = iv.input_value_id
1148: and iv.input_value_id = iv_rec.input_value_id
1149: and userenv('LANG') = iv_tl.language
1150: and iv.effective_start_date <= p_validation_end_date

Line 1391: from pay_input_values_f iv1

1387: begin
1388: --
1389: select 'Y'
1390: into l_on_final_record
1391: from pay_input_values_f iv1
1392: where p_input_value_id = iv1.input_value_id
1393: and p_session_date between
1394: iv1.effective_start_date and iv1.effective_end_date
1395: and iv1.effective_end_date =

Line 1397: from pay_input_values_f iv2

1393: and p_session_date between
1394: iv1.effective_start_date and iv1.effective_end_date
1395: and iv1.effective_end_date =
1396: (select max(iv2.effective_end_date)
1397: from pay_input_values_f iv2
1398: where p_input_value_id = iv2.input_value_id);
1399: --
1400: exception
1401: when NO_DATA_FOUND then NULL;