APPS.PAY_AU_PAYE_FF dependencies on PAY_INPUT_VALUES_F

Line 1737: pay_input_values_f piv,

1733: pay_element_entry_values_f peev,
1734: pay_element_links_f pelf,
1735: pay_element_types_f pet,
1736: pay_element_classifications pec,
1737: pay_input_values_f piv,
1738: pay_assignment_actions paa
1739: where paa.assignment_action_id = p_assignment_action_id
1740: and pee.assignment_id = paa.assignment_id
1741: and pee.creator_type IN ('EE','RR')

Line 2061: pay_input_values_f piv,

2057: is
2058: select 'Y'
2059: from
2060: pay_element_types_f pet,
2061: pay_input_values_f piv,
2062: pay_run_result_values prrv,
2063: pay_run_results prr,
2064: pay_assignment_actions paa,
2065: pay_payroll_actions ppa,

Line 2104: pay_input_values_f piv,

2100: and not exists(
2101: select piv.name
2102: from
2103: pay_element_types_f pet,
2104: pay_input_values_f piv,
2105: pay_input_values_f piv1,
2106: pay_element_links_f pel, /* Bug#2563515 */
2107: pay_element_entries_f peef, /* Bug#2563515 */
2108: pay_element_entry_values_f peev,

Line 2105: pay_input_values_f piv1,

2101: select piv.name
2102: from
2103: pay_element_types_f pet,
2104: pay_input_values_f piv,
2105: pay_input_values_f piv1,
2106: pay_element_links_f pel, /* Bug#2563515 */
2107: pay_element_entries_f peef, /* Bug#2563515 */
2108: pay_element_entry_values_f peev,
2109: pay_element_entry_values_f peev1

Line 2320: pay_input_values_f piv

2316: SELECT prv.result_value
2317: from pay_run_results prr,
2318: pay_run_result_values prv,
2319: pay_element_types_f pet,
2320: pay_input_values_f piv
2321: where prr.assignment_action_id = p_assignment_action_id
2322: and prv.run_result_id = prr.run_result_id
2323: and prv.input_value_id = piv.input_value_id
2324: and prr.element_type_id = pet.element_type_id

Line 2331: FROM pay_input_values_f pivf, per_pay_bases ppb

2327: and pet.element_name= 'Normal Hours');
2328:
2329: CURSOR Cr_element_type_id IS (
2330: SELECT pivf.element_type_id /*Bug# 3665680*/
2331: FROM pay_input_values_f pivf, per_pay_bases ppb
2332: WHERE pivf.input_value_id = ppb.input_value_id
2333: AND ppb.pay_basis_id = p_pay_bases_id);
2334:
2335: BEGIN

Line 2502: pay_input_values_f piv,

2498:
2499: cursor get_period_spread_over is
2500: select prv.RESULT_VALUE period_spread_over, prr.run_result_id, pee.creator_type
2501: from pay_element_types_f pet,
2502: pay_input_values_f piv,
2503: pay_run_result_values prv,
2504: pay_run_results prr,
2505: pay_element_entries_f pee
2506: where prr.assignment_action_id=p_assignment_action_id

Line 2523: from pay_input_values_f piv,

2519: and p_date_paid between pee.effective_start_date and pee.effective_end_date;
2520:
2521: cursor get_spread_earning(p_run_result_id pay_run_results.run_result_id%type) is
2522: select prv.RESULT_VALUE
2523: from pay_input_values_f piv,
2524: pay_run_result_values prv,
2525: pay_run_results prr
2526: where prr.RUN_RESULT_ID = p_run_result_id
2527: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID

Line 2537: pay_input_values_f piv,

2533: /* new cursor for bug 6669058 */
2534: cursor get_retro_spread_earning is
2535: select nvl(sum(prv.RESULT_VALUE),0)
2536: from pay_element_types_f pet,
2537: pay_input_values_f piv,
2538: pay_run_result_values prv,
2539: pay_run_results prr,
2540: pay_element_entries_f pee
2541: where prr.assignment_action_id=p_assignment_action_id

Line 2624: pay_input_values_f piv,

2620:
2621: cursor get_retro_spread_earning is
2622: select nvl(sum(prv.RESULT_VALUE),0)
2623: from pay_element_types_f pet,
2624: pay_input_values_f piv,
2625: pay_run_result_values prv,
2626: pay_run_results prr,
2627: pay_element_entries_f pee
2628: where prr.assignment_action_id=p_assignment_action_id

Line 2677: pay_input_values_f piv,

2673: cursor etp_pay_csr ( c_assignment_id per_all_assignments_f.assignment_id%type,
2674: c_date_earned date) is
2675: select peev.screen_entry_value
2676: from pay_element_types_f pet,
2677: pay_input_values_f piv,
2678: pay_element_entries_f pee,
2679: pay_element_entry_values_f peev
2680: where pee.assignment_id = c_assignment_id
2681: and piv.name ='Pay ETP Components'