APPS.PAY_AC_ACTION_ARCH dependencies on PAY_INPUT_VALUES_F

Line 1638: pay_input_values_f piv,

1634: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1635: sum(decode(piv.name, 'Rate', prrv.result_value))
1636: from pay_run_results prr,
1637: pay_run_result_values prrv,
1638: pay_input_values_f piv,
1639: pay_entry_process_details pepd
1640: where piv.input_value_id = prrv.input_value_id
1641: and prr.element_type_id = cp_element_type_id
1642: and prr.run_result_id = prrv.run_result_id

Line 2796: from pay_input_values_f pivf,

2792: FETCH c_cur_home_state_jd INTO lv_jurisdiction_flag;
2793: CLOSE c_cur_home_state_jd;
2794: ELSE
2795: select nvl((select peevf.screen_entry_value jurisdiction_code
2796: from pay_input_values_f pivf,
2797: pay_element_entry_values_f peevf
2798: where pivf.element_type_id = ln_element_type_id
2799: AND pivf.NAME = 'Jurisdiction'
2800: AND peevf.element_entry_id = ln_element_entry_id

Line 4835: pay_input_values_f pivf

4831: ) IS
4832: SELECT to_number(prrv.result_value), pivf.NAME
4833: FROM pay_run_results prr,
4834: pay_run_result_values prrv,
4835: pay_input_values_f pivf
4836: WHERE prr.assignment_action_id = cp_run_assignment_action_id
4837: AND prr.element_entry_id = cp_element_entry_id
4838: AND prrv.run_result_id = prr.run_result_id
4839: AND prrv.input_value_id = pivf.input_value_id

Line 4853: pay_input_values_f PIVF,

4849: ) is
4850: select PRRV.RESULT_VALUE as original_input_value
4851: from pay_run_results PRR,
4852: pay_run_result_values PRRV,
4853: pay_input_values_f PIVF,
4854: pay_entry_process_details PEPD
4855: WHERE PEPD.ELEMENT_ENTRY_ID = cp_element_entry_id
4856: AND PEPD.SOURCE_ENTRY_ID = PRR.SOURCE_ID
4857: AND PEPD.RUN_RESULT_ID = PRR.RUN_RESULT_ID

Line 4877: pay_input_values_f pivf

4873: ) IS
4874: SELECT to_number(prrv.result_value)
4875: FROM pay_run_results prr,
4876: pay_run_result_values prrv,
4877: pay_input_values_f pivf
4878: WHERE prr.assignment_action_id = cp_run_assignment_action_id
4879: AND prr.element_entry_id = cp_element_entry_id
4880: AND prrv.run_result_id = prr.run_result_id
4881: AND prrv.input_value_id = pivf.input_value_id

Line 5112: from pay_input_values_f pivf,

5108: CLOSE c_cur_home_state_jd;
5109: ELSE
5110:
5111: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
5112: from pay_input_values_f pivf,
5113: pay_element_entry_values_f peevf
5114: where pivf.element_type_id = p_element_type_id
5115: AND pivf.NAME = 'Jurisdiction'
5116: AND peevf.element_entry_id = ln_element_entry_id

Line 5429: pay_input_values_f pivf

5425: --bug 7373188
5426: SELECT to_number(prrv.result_value), pivf.NAME
5427: FROM pay_run_results prr,
5428: pay_run_result_values prrv,
5429: pay_input_values_f pivf
5430: WHERE prr.element_entry_id = cp_element_entry_id
5431: --bug 7373188
5432: and prr.assignment_action_id = cp_run_action_id
5433: --bug 7373188

Line 5450: pay_input_values_f pivf

5446: --bug 7373188
5447: SELECT to_number(prrv.result_value)
5448: FROM pay_run_results prr,
5449: pay_run_result_values prrv,
5450: pay_input_values_f pivf
5451: WHERE prr.element_entry_id = cp_element_entry_id
5452: --bug 7373188
5453: and prr.assignment_action_id = cp_run_action_id
5454: --bug 7373188

Line 5667: from pay_input_values_f pivf,

5663: CLOSE c_cur_home_state_jd;
5664: ELSE
5665:
5666: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
5667: from pay_input_values_f pivf,
5668: pay_element_entry_values_f peevf
5669: where pivf.element_type_id = p_element_type_id
5670: AND pivf.NAME = 'Jurisdiction'
5671: AND peevf.element_entry_id = ln_element_entry_id

Line 6030: pay_input_values_f pivf

6026: --bug 7373188
6027: SELECT to_number(prrv.result_value), pivf.NAME
6028: FROM pay_run_results prr,
6029: pay_run_result_values prrv,
6030: pay_input_values_f pivf
6031: WHERE prr.element_entry_id = cp_element_entry_id
6032: --bug 7373188
6033: and prr.assignment_action_id = cp_run_action_id
6034: --bug 7373188

Line 6051: pay_input_values_f pivf

6047: --bug 7373188
6048: SELECT to_number(prrv.result_value)
6049: FROM pay_run_results prr,
6050: pay_run_result_values prrv,
6051: pay_input_values_f pivf
6052: WHERE prr.element_entry_id = cp_element_entry_id
6053: --bug 7373188
6054: and prr.assignment_action_id = cp_run_action_id
6055: --bug 7373188

Line 6279: from pay_input_values_f pivf,

6275: CLOSE c_cur_home_state_jd;
6276: ELSE
6277:
6278: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
6279: from pay_input_values_f pivf,
6280: pay_element_entry_values_f peevf
6281: where pivf.element_type_id = p_element_type_id
6282: AND pivf.NAME = 'Jurisdiction'
6283: AND peevf.element_entry_id = ln_element_entry_id