APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on PAY_PAYROLL_ACTIONS

Line 111: pay_payroll_actions ppa

107:
108: Cursor csr_head_count Is
109: Select action_information24
110: From pay_action_information paa,
111: pay_payroll_actions ppa
112: Where paa.action_context_id = ppa.payroll_action_id
113: and action_information_category ='FR_DUCS_PAGE_INFO'
114: and action_information1 = p_establishment_id
115: and action_information2 = 'ASSEDIC'

Line 296: pay_payroll_actions ppa,

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 ,
300: pay_element_classifications pec ,

Line 338: pay_payroll_actions ppa,

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
342: Where pet.element_type_id = piv.element_type_id

Line 367: pay_payroll_actions ppa ,

363: pay_balance_pkg.get_value(g_conventional_indemnity_id,max(paa.assignment_action_id)) conventional,
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')