APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_INPUT_VALUES_F

Line 574: from pay_input_values_f piv,

570:
571: cursor c_bases_element (cp_pay_basis_id in number,
572: cp_date_earned in date) is
573: select piv.element_type_id, piv.input_value_id
574: from pay_input_values_f piv,
575: per_pay_bases ppb
576: where ppb.pay_basis_id = cp_pay_basis_id
577: and ppb.input_value_id = piv.input_value_id
578: and cp_date_earned between piv.effective_start_date

Line 587: pay_input_values_f piv,

583: cp_date_earned in date ) is
584: select prrv.result_value
585: from pay_run_results prr,
586: pay_run_result_values prrv,
587: pay_input_values_f piv,
588: pay_assignment_actions paa,
589: pay_payroll_actions ppa
590: where prr.element_type_id + 0 = piv.element_type_id
591: and prr.run_result_id = prrv.run_result_id

Line 609: pay_input_values_f piv,

605: cp_date_earned in date ) is
606: select prrv.result_value
607: from pay_run_results prr,
608: pay_run_result_values prrv,
609: pay_input_values_f piv,
610: pay_assignment_actions paa,
611: pay_payroll_actions ppa
612: where prr.element_type_id + 0 = piv.element_type_id
613: and prr.run_result_id = prrv.run_result_id

Line 773: pay_input_values_f piv

769: piv.name, piv.uom
770: from pay_element_types_f pet,
771: pay_element_entries_f pee,
772: pay_element_entry_values_f peev,
773: pay_input_values_f piv
774: where pet.element_type_id = cp_element_type_id
775: and pet.element_type_id = pee.element_type_id
776: and pee.assignment_id = cp_assignment_id
777: and pee.element_entry_id = peev.element_entry_id

Line 1413: pay_input_values_f piv

1409: cursor c_pay_basis(cp_pay_basis_id in number
1410: ,cp_effective_date in date) is
1411: select ppb.name
1412: from per_pay_bases ppb,
1413: pay_input_values_f piv
1414: where ppb.pay_basis_id = cp_pay_basis_id
1415: and piv.input_value_id = ppb.input_value_id
1416: and p_effective_date between piv.effective_start_date
1417: and piv.effective_end_date;