APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PAY_INPUT_VALUES_F

Line 118: , pay_input_values_f piv

114: ) is
115: select nvl(to_number(val.screen_entry_value),0)
116: from pay_element_entries_f ent
117: , pay_element_types_f el
118: , pay_input_values_f piv
119: , pay_element_entry_values_f val
120: , pay_element_links_f link
121: where ent.assignment_id = p_assignment_id
122: and ent.element_entry_id = val.element_entry_id

Line 145: , pay_input_values_f piv

141: ) is
142: select nvl(val.screen_entry_value,'Y')
143: from pay_element_entries_f ent
144: , pay_element_types_f el
145: , pay_input_values_f piv
146: , pay_element_entry_values_f val
147: , pay_element_links_f link
148: where ent.assignment_id = p_assignment_id
149: and ent.element_entry_id = val.element_entry_id

Line 2108: , pay_input_values_f input

2104: to consider the assignment action id into account.*/
2105: cursor csr_get_rate is
2106: select to_number(result.result_value)
2107: from pay_run_results runs
2108: , pay_input_values_f input
2109: , pay_run_result_values result
2110: , pay_assignment_actions paa
2111: , pay_assignment_actions cur_paa
2112: , pay_payroll_actions cur_ppa

Line 2289: ,pay_input_values_f alp_piv

2285: SELECT to_number(nvl(prrv.result_value,0))
2286: FROM pay_run_result_values prrv
2287: ,pay_run_results prr
2288: ,pay_element_types_f alp_pet
2289: ,pay_input_values_f alp_piv
2290: ,pay_element_entries_f pee
2291: ,pay_element_links_f pel
2292: ,pay_element_types_f abs_pet
2293: ,pay_input_values_f abs_piv

Line 2293: ,pay_input_values_f abs_piv

2289: ,pay_input_values_f alp_piv
2290: ,pay_element_entries_f pee
2291: ,pay_element_links_f pel
2292: ,pay_element_types_f abs_pet
2293: ,pay_input_values_f abs_piv
2294: ,pay_accrual_plans pap
2295: WHERE prr.run_result_id = prrv.run_result_id
2296: AND prr.assignment_action_id = c_assignment_action_id
2297: AND prr.element_type_id = alp_pet.element_type_id