DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_INPUT_VALUES_F

Line 1376: from pay_input_values_f piv,

1372:
1373: cursor c_bases_element (cp_pay_basis_id in number,
1374: cp_period_to_date in date) is
1375: select piv.element_type_id, piv.input_value_id
1376: from pay_input_values_f piv,
1377: per_pay_bases ppb
1378: where ppb.pay_basis_id = cp_pay_basis_id
1379: and ppb.input_value_id = piv.input_value_id
1380: and cp_period_to_date between piv.effective_start_date

Line 1389: pay_input_values_f piv,

1385: cp_period_to_date in date ) is
1386: select prrv.result_value
1387: from pay_run_results prr,
1388: pay_run_result_values prrv,
1389: pay_input_values_f piv,
1390: pay_assignment_actions paa,
1391: pay_payroll_actions ppa
1392: where prr.element_type_id = piv.element_type_id
1393: and prr.run_result_id = prrv.run_result_id

Line 1411: pay_input_values_f piv,

1407: cp_period_to_date in date ) is
1408: select prrv.result_value
1409: from pay_run_results prr,
1410: pay_run_result_values prrv,
1411: pay_input_values_f piv,
1412: pay_assignment_actions paa,
1413: pay_payroll_actions ppa
1414: where prr.element_type_id = piv.element_type_id
1415: and prr.run_result_id = prrv.run_result_id