APPS.PAY_AC_ACTION_ARCH dependencies on PAY_INPUT_VALUES_F

Line 1329: pay_input_values_f piv,

1325: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1326: sum(decode(piv.name, 'Rate', prrv.result_value))
1327: from pay_run_results prr,
1328: pay_run_result_values prrv,
1329: pay_input_values_f piv,
1330: pay_entry_process_details pepd
1331: where piv.input_value_id = prrv.input_value_id
1332: and prr.element_type_id = cp_element_type_id
1333: and prr.run_result_id = prrv.run_result_id

Line 2318: from pay_input_values_f pivf,

2314: FETCH c_cur_home_state_jd INTO lv_jurisdiction_flag;
2315: CLOSE c_cur_home_state_jd;
2316: ELSE
2317: select nvl((select peevf.screen_entry_value jurisdiction_code
2318: from pay_input_values_f pivf,
2319: pay_element_entry_values_f peevf
2320: where pivf.element_type_id = ln_element_type_id
2321: AND pivf.NAME = 'Jurisdiction'
2322: AND peevf.element_entry_id = ln_element_entry_id

Line 4322: pay_input_values_f pivf

4318: CURSOR get_run_results ( cp_element_entry_id in number ) IS
4319: SELECT to_number(prrv.result_value), pivf.NAME
4320: FROM pay_run_results prr,
4321: pay_run_result_values prrv,
4322: pay_input_values_f pivf
4323: WHERE prr.element_entry_id = cp_element_entry_id
4324: AND prrv.run_result_id = prr.run_result_id
4325: AND prrv.input_value_id = pivf.input_value_id
4326: AND pivf.NAME IN ('Pay Value', 'Hours')

Line 4335: pay_input_values_f pivf

4331: CURSOR get_run_results_rate( cp_element_entry_id in number ) IS
4332: SELECT to_number(prrv.result_value)
4333: FROM pay_run_results prr,
4334: pay_run_result_values prrv,
4335: pay_input_values_f pivf
4336: WHERE prr.element_entry_id = cp_element_entry_id
4337: AND prrv.run_result_id = prr.run_result_id
4338: AND prrv.input_value_id = pivf.input_value_id
4339: AND pivf.NAME IN ('Rate');

Line 4511: from pay_input_values_f pivf,

4507: CLOSE c_cur_home_state_jd;
4508: ELSE
4509:
4510: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
4511: from pay_input_values_f pivf,
4512: pay_element_entry_values_f peevf
4513: where pivf.element_type_id = p_element_type_id
4514: AND pivf.NAME = 'Jurisdiction'
4515: AND peevf.element_entry_id = ln_element_entry_id

Line 4816: pay_input_values_f pivf

4812: --bug 7373188
4813: SELECT to_number(prrv.result_value), pivf.NAME
4814: FROM pay_run_results prr,
4815: pay_run_result_values prrv,
4816: pay_input_values_f pivf
4817: WHERE prr.element_entry_id = cp_element_entry_id
4818: --bug 7373188
4819: and prr.assignment_action_id = cp_run_action_id
4820: --bug 7373188

Line 4834: pay_input_values_f pivf

4830: --bug 7373188
4831: SELECT to_number(prrv.result_value)
4832: FROM pay_run_results prr,
4833: pay_run_result_values prrv,
4834: pay_input_values_f pivf
4835: WHERE prr.element_entry_id = cp_element_entry_id
4836: --bug 7373188
4837: and prr.assignment_action_id = cp_run_action_id
4838: --bug 7373188

Line 5046: from pay_input_values_f pivf,

5042: CLOSE c_cur_home_state_jd;
5043: ELSE
5044:
5045: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
5046: from pay_input_values_f pivf,
5047: pay_element_entry_values_f peevf
5048: where pivf.element_type_id = p_element_type_id
5049: AND pivf.NAME = 'Jurisdiction'
5050: AND peevf.element_entry_id = ln_element_entry_id