APPS.PAY_US_ACTION_ARCH dependencies on PAY_INPUT_VALUES_F

Line 1903: pay_input_values_f piv,

1899: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1900: sum(decode(piv.name, 'Rate', prrv.result_value))
1901: from pay_run_results prr,
1902: pay_run_result_values prrv,
1903: pay_input_values_f piv,
1904: pay_entry_process_details pepd
1905: where piv.input_value_id = prrv.input_value_id
1906: and prr.element_type_id = cp_element_type_id
1907: and prr.run_result_id = prrv.run_result_id

Line 6253: pay_input_values_f piv_att,

6249: ,peef.entry_information3 -- DOC Number
6250: ,paa.assignment_action_id
6251: ,pet.element_type_id
6252: from pay_element_entry_values_f peev,
6253: pay_input_values_f piv_att,
6254: pay_element_entries_f peef,
6255: pay_run_results prr_att,
6256: pay_run_results prr_pay,
6257: pay_payroll_actions ppa,

Line 6261: pay_input_values_f piv_pay,

6257: pay_payroll_actions ppa,
6258: pay_assignment_actions paa,
6259: pay_action_interlocks pai,
6260: pay_pre_payments ppp,
6261: pay_input_values_f piv_pay,
6262: pay_run_result_values prrv_att,
6263: pay_run_result_values prrv_pay,
6264: pay_element_types_f pet,
6265: pay_element_types_f pet_calc,

Line 6337: pay_input_values_f piv_att,

6333: ,paa.assignment_action_id
6334: ,peef.element_type_id
6335: from pay_element_entry_values_f peev,
6336: pay_element_entry_values_f peev_pay,
6337: pay_input_values_f piv_att,
6338: pay_element_entries_f peef,
6339: pay_run_results prr_att,
6340: pay_run_results prr_pay,
6341: pay_payroll_actions ppa,

Line 6345: pay_input_values_f piv_pay,

6341: pay_payroll_actions ppa,
6342: pay_assignment_actions paa,
6343: pay_action_interlocks pai,
6344: pay_pre_payments ppp,
6345: pay_input_values_f piv_pay,
6346: pay_run_result_values prrv_att,
6347: pay_run_result_values prrv_pay
6348: where round(ppp.value ,2) = round(p_value ,2)
6349: and ppp.pre_payment_id = p_pre_payment_id

Line 6405: pay_input_values_f piv,

6401: cursor jur ( ass_act_id number, ele_type_id number, date_ear date ) IS
6402: select prrv.result_value
6403: from pay_run_results prr,
6404: pay_run_result_values prrv,
6405: pay_input_values_f piv,
6406: pay_element_types_f pet,
6407: pay_element_types_f pet1
6408: where prr.assignment_action_id = ass_act_id and
6409: pet1.element_type_id = ele_type_id and

Line 6445: pay_input_values_f piv_att,

6441: select pet.element_type_id
6442: ,to_char(ppa.date_earned, 'DD-MM-YYYY')
6443: ,nvl(element_information4,-1)
6444: from pay_element_entry_values_f peev,
6445: pay_input_values_f piv_att,
6446: pay_element_entries_f peef,
6447: pay_run_results prr_att,
6448: pay_payroll_actions ppa,
6449: pay_assignment_actions paa,