DBA Data[Home] [Help]

APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on PAY_ASSIGNMENT_ACTIONS

Line 295: pay_assignment_actions paa,

291: pap.information6 accounting_method,
292: sum(decode(piv.name,'Pay Value',prrv.result_value)) ,
293: sum(decode(piv.name,'Rate',prrv.result_value))
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 ,

Line 339: pay_assignment_actions paa,

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
342: Where pet.element_type_id = piv.element_type_id
343: and ppa.payroll_action_id = paa.payroll_action_id

Line 368: pay_assignment_actions paa

364: pay_balance_pkg.get_value(g_contractual_indemnity_id,max(paa.assignment_action_id)) contractual,
365: pay_balance_pkg.get_value(g_transactional_indemnity_id,max(paa.assignment_action_id)) transactional
366: From
367: pay_payroll_actions ppa ,
368: pay_assignment_actions paa
369: Where ppa.payroll_action_id = paa.payroll_action_id
370: and paa.assignment_id = p_assignment_id
371: and ppa.action_type in ('R' ,'Q')
372: and paa.action_status = 'C'