DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_INPUT_VALUES_F

Line 788: from pay_input_values_f piv,

784:
785: cursor c_bases_element (cp_pay_basis_id in number,
786: cp_period_to_date in date) is
787: select piv.element_type_id, piv.input_value_id
788: from pay_input_values_f piv,
789: per_pay_bases ppb
790: where ppb.pay_basis_id = cp_pay_basis_id
791: and ppb.input_value_id = piv.input_value_id
792: and cp_period_to_date between piv.effective_start_date

Line 801: pay_input_values_f piv,

797: cp_period_to_date in date ) is
798: select prrv.result_value
799: from pay_run_results prr,
800: pay_run_result_values prrv,
801: pay_input_values_f piv,
802: pay_assignment_actions paa,
803: pay_payroll_actions ppa
804: where prr.element_type_id = piv.element_type_id
805: and prr.run_result_id = prrv.run_result_id

Line 823: pay_input_values_f piv,

819: cp_period_to_date in date ) is
820: select prrv.result_value
821: from pay_run_results prr,
822: pay_run_result_values prrv,
823: pay_input_values_f piv,
824: pay_assignment_actions paa,
825: pay_payroll_actions ppa
826: where prr.element_type_id = piv.element_type_id
827: and prr.run_result_id = prrv.run_result_id