APPS.PAY_AU_SOE_PKG dependencies on PAY_INPUT_VALUES_F

Line 878: pay_input_values_f piv,

874: select distinct prrv.result_value ,prr.element_entry_id
875: from
876: pay_run_results prr,
877: pay_run_result_values prrv,
878: pay_input_values_f piv,
879: pay_element_types_f pet,
880: pay_element_classifications pec
881: where prr.source_id= p_source_id
882: and piv.input_value_id=prrv.input_value_id

Line 903: pay_input_values_f piv,

899: select distinct prrv.result_value ,prr.element_entry_id
900: from
901: pay_run_results prr,
902: pay_run_result_values prrv,
903: pay_input_values_f piv,
904: pay_element_types_f pet,
905: pay_element_classifications pec,
906: pay_element_entries_f pee,
907: pay_element_entries_f pee1

Line 936: pay_input_values_f piv,

932: pay_element_entries_f pee1,
933: pay_run_results prr,
934: pay_run_results prr1,
935: pay_run_result_values prrv,
936: pay_input_values_f piv,
937: pay_element_types_f pet,
938: pay_element_classifications pec
939: where pee.element_entry_id=p_source_id
940: and pee.source_id =prr.run_result_id

Line 1139: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1135: RETURN NUMBER
1136: IS
1137:
1138: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1139: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1140:
1141: l_result NUMBER := NULL;
1142: l_temp NUMBER := NULL;
1143:

Line 1149: pay_input_values_f piv

1145: SELECT prv.result_value
1146: from pay_run_results prr,
1147: pay_run_result_values prv,
1148: pay_element_types_f pet,
1149: pay_input_values_f piv
1150: where prr.assignment_action_id = p_assignment_action_id
1151: and prv.run_result_id = prr.run_result_id
1152: and prv.input_value_id = piv.input_value_id
1153: and prr.element_type_id = pet.element_type_id

Line 1160: FROM pay_input_values_f pivf, per_pay_bases ppb

1156: and pet.element_name= 'Normal Hours');
1157:
1158: CURSOR Cr_element_type_id IS (
1159: SELECT pivf.element_type_id
1160: FROM pay_input_values_f pivf, per_pay_bases ppb
1161: WHERE pivf.input_value_id = ppb.input_value_id
1162: AND ppb.pay_basis_id = p_pay_bases_id);
1163:
1164: /* Bug 5967108 - Added Check for Input with Name - Hours */

Line 1172: FROM pay_input_values_f pivf

1168: IS
1169: SELECT pivf.input_value_id
1170: ,pivf.name
1171: ,decode(pivf.name,'Hours',1,2) sort_index
1172: FROM pay_input_values_f pivf
1173: WHERE pivf.element_type_id = c_element_type_id
1174: AND substr(pivf.uom,1,1) = 'H'
1175: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date
1176: ORDER BY sort_index;

Line 1253: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1249: RETURN NUMBER
1250: IS
1251:
1252: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1253: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1254:
1255: l_result number := NULL;
1256:
1257: CURSOR get_rate_input_value

Line 1262: FROM pay_input_values_f pivf

1258: (c_element_type_id pay_element_types_f.element_type_id%TYPE
1259: ,c_effective_date date)
1260: IS
1261: SELECT pivf.input_value_id
1262: FROM pay_input_values_f pivf
1263: WHERE pivf.element_type_id = c_element_type_id
1264: AND upper(pivf.name) like 'RATE%'
1265: AND pivf.uom in ('N','M','I') /*bug 6109668 */
1266: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;

Line 1334: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1330: RETURN NUMBER
1331: IS
1332:
1333: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1334: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1335:
1336: l_result number := NULL;
1337:
1338: CURSOR get_hours_input_value

Line 1343: FROM pay_input_values_f pivf

1339: (c_element_type_id pay_element_types_f.element_type_id%TYPE
1340: ,c_effective_date date)
1341: IS
1342: SELECT pivf.input_value_id
1343: FROM pay_input_values_f pivf
1344: WHERE pivf.element_type_id = c_element_type_id
1345: and pivf.name IN ('Hours','Days')
1346: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;
1347: