APPS.HR_PRE_PAY dependencies on PAY_INPUT_VALUES_F

Line 2294: pay_input_values_f piv,

2290: assign_action_id,
2291: pay_act_id,
2292: run_date_earned
2293: from
2294: pay_input_values_f piv,
2295: pay_element_types_f pet,
2296: pay_run_result_values rrv,
2297: pay_run_results prr2,
2298: pay_run_results prr,

Line 2336: pay_input_values_f piv,

2332: if (g_adjust_ee_source = 'T') then
2333: select fnd_number.canonical_to_number(rrv.result_value)
2334: into adj_value
2335: from
2336: pay_input_values_f piv,
2337: pay_element_types_f pet,
2338: pay_run_result_values rrv,
2339: pay_run_results prr2,
2340: pay_run_results prr

Line 2363: pay_input_values_f piv,

2359: select fnd_number.canonical_to_number(rrv.result_value)
2360: into adj_value
2361: from
2362: pay_element_entries_f pee,
2363: pay_input_values_f piv,
2364: pay_element_types_f pet,
2365: pay_run_result_values rrv,
2366: pay_run_results prr2,
2367: pay_run_results prr

Line 2723: index(piv pay_input_values_f_pk) */

2719: cursor get_orgs (p_asg_action in number,
2720: p_org_context_name in varchar2)
2721: is
2722: select /*+ use_nl(prrv piv)
2723: index(piv pay_input_values_f_pk) */
2724: distinct (prrv.result_value) organization_id
2725: from pay_run_result_values prrv,
2726: pay_input_values_f piv,
2727: pay_run_results prr,

Line 2726: pay_input_values_f piv,

2722: select /*+ use_nl(prrv piv)
2723: index(piv pay_input_values_f_pk) */
2724: distinct (prrv.result_value) organization_id
2725: from pay_run_result_values prrv,
2726: pay_input_values_f piv,
2727: pay_run_results prr,
2728: pay_assignment_actions paa,
2729: pay_payroll_actions ppa,
2730: pay_action_interlocks pai