APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_INPUT_VALUES_F

Line 613: from pay_input_values_f piv,

609:
610: cursor c_bases_element (cp_pay_basis_id in number,
611: cp_date_earned in date) is
612: select piv.element_type_id, piv.input_value_id
613: from pay_input_values_f piv,
614: per_pay_bases ppb
615: where ppb.pay_basis_id = cp_pay_basis_id
616: and ppb.input_value_id = piv.input_value_id
617: and cp_date_earned between piv.effective_start_date

Line 626: pay_input_values_f piv,

622: cp_date_earned in date ) is
623: select prrv.result_value
624: from pay_run_results prr,
625: pay_run_result_values prrv,
626: pay_input_values_f piv,
627: pay_assignment_actions paa,
628: pay_payroll_actions ppa
629: where prr.element_type_id + 0 = piv.element_type_id
630: and prr.run_result_id = prrv.run_result_id

Line 648: pay_input_values_f piv,

644: cp_date_earned in date ) is
645: select prrv.result_value
646: from pay_run_results prr,
647: pay_run_result_values prrv,
648: pay_input_values_f piv,
649: pay_assignment_actions paa,
650: pay_payroll_actions ppa
651: where prr.element_type_id + 0 = piv.element_type_id
652: and prr.run_result_id = prrv.run_result_id

Line 815: pay_input_values_f piv

811: from pay_element_types_f pet,
812: pay_element_types_f_tl petl,
813: pay_element_entries_f pee,
814: pay_element_entry_values_f peev,
815: pay_input_values_f piv
816: where pet.element_type_id = cp_element_type_id
817: and pet.element_type_id = pee.element_type_id
818: and pee.assignment_id = cp_assignment_id
819: and pee.element_entry_id = peev.element_entry_id

Line 1483: pay_input_values_f piv

1479: cursor c_pay_basis(cp_pay_basis_id in number
1480: ,cp_effective_date in date) is
1481: select ppb.name
1482: from per_pay_bases ppb,
1483: pay_input_values_f piv
1484: where ppb.pay_basis_id = cp_pay_basis_id
1485: and piv.input_value_id = ppb.input_value_id
1486: and p_effective_date between piv.effective_start_date
1487: and piv.effective_end_date;