DBA Data[Home] [Help]

APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on PAY_INPUT_VALUES_F

Line 298: pay_input_values_f piv_base,

294: From
295: pay_assignment_actions paa,
296: pay_payroll_actions ppa,
297: pay_accrual_plans pap ,
298: pay_input_values_f piv_base,
299: pay_element_types_f pet ,
300: pay_element_classifications pec ,
301: pay_run_results prr,
302: pay_input_values_f piv,

Line 302: pay_input_values_f piv,

298: pay_input_values_f piv_base,
299: pay_element_types_f pet ,
300: pay_element_classifications pec ,
301: pay_run_results prr,
302: pay_input_values_f piv,
303: pay_run_result_values prrv
304: Where paa.assignment_id = p_assignment_id
305: and ppa.payroll_action_id = paa.payroll_action_id
306: and ppa.date_earned >= p_last_day_worked

Line 337: pay_input_values_f piv ,

333: Select
334: sum(decode(pet.element_name,'FR_FIXED_TERM_CONTRACT_INDEMNITY_PAY',prrv.result_value))
335: From
336: pay_element_types_f pet ,
337: pay_input_values_f piv ,
338: pay_payroll_actions ppa,
339: pay_assignment_actions paa,
340: pay_run_results prr,
341: pay_run_result_values prrv