eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_SOE_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 877: pay_run_result_values prrv,

873: is
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

Line 902: pay_run_result_values prrv,

898: is
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,

Line 935: pay_run_result_values prrv,

931: from pay_element_entries_f pee,
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

Line 1147: pay_run_result_values prv,

1143:
1144: CURSOR Cr_value IS (
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

Line 1179: (c_run_result_id pay_run_result_values.run_result_id%TYPE

1175: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date
1176: ORDER BY sort_index;
1177:
1178: CURSOR get_hours_result_value
1179: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1180: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1181: IS
1182: SELECT prrv.result_value
1183: FROM pay_run_result_values prrv

Line 1180: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

1176: ORDER BY sort_index;
1177:
1178: CURSOR get_hours_result_value
1179: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1180: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1181: IS
1182: SELECT prrv.result_value
1183: FROM pay_run_result_values prrv
1184: WHERE prrv.run_result_id = c_run_result_id

Line 1183: FROM pay_run_result_values prrv

1179: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1180: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1181: IS
1182: SELECT prrv.result_value
1183: FROM pay_run_result_values prrv
1184: WHERE prrv.run_result_id = c_run_result_id
1185: AND prrv.input_value_id = c_input_value_id;
1186:
1187:

Line 1269: (c_run_result_id pay_run_result_values.run_result_id%TYPE

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;
1267:
1268: CURSOR get_rate_result_value
1269: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1270: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1271: IS
1272: SELECT prrv.result_value
1273: FROM pay_run_result_values prrv

Line 1270: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

1266: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;
1267:
1268: CURSOR get_rate_result_value
1269: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1270: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1271: IS
1272: SELECT prrv.result_value
1273: FROM pay_run_result_values prrv
1274: WHERE prrv.run_result_id = c_run_result_id

Line 1273: FROM pay_run_result_values prrv

1269: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1270: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1271: IS
1272: SELECT prrv.result_value
1273: FROM pay_run_result_values prrv
1274: WHERE prrv.run_result_id = c_run_result_id
1275: AND prrv.input_value_id = c_input_value_id;
1276:
1277: BEGIN

Line 1349: (c_run_result_id pay_run_result_values.run_result_id%TYPE

1345: and pivf.name IN ('Hours','Days')
1346: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;
1347:
1348: CURSOR get_hours_result_value
1349: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1350: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1351: IS
1352: SELECT prrv.result_value
1353: FROM pay_run_result_values prrv

Line 1350: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

1346: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;
1347:
1348: CURSOR get_hours_result_value
1349: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1350: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1351: IS
1352: SELECT prrv.result_value
1353: FROM pay_run_result_values prrv
1354: WHERE prrv.run_result_id = c_run_result_id

Line 1353: FROM pay_run_result_values prrv

1349: (c_run_result_id pay_run_result_values.run_result_id%TYPE
1350: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
1351: IS
1352: SELECT prrv.result_value
1353: FROM pay_run_result_values prrv
1354: WHERE prrv.run_result_id = c_run_result_id
1355: AND prrv.input_value_id = c_input_value_id;
1356:
1357: BEGIN