APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on PAY_ELEMENT_TYPES_F

Line 142: pay_element_types_f pet

138: 'A' flag ,decode(c_type,'ARRCO',entry_information2 ,'AGIRC' ,entry_information4) "Pension_Provider_Id"
139: From
140: pay_element_entries_f peef ,
141: pay_element_links_f pel ,
142: pay_element_types_f pet
143: Where peef.assignment_id = c_assignment_id
144: and peef.element_link_id = pel.element_link_id
145: and pel.element_type_id = pet.element_type_id
146: and p_termination_date between peef.effective_start_date and peef.effective_end_date

Line 224: pay_element_types_f pet

220: Select hr_reports.get_lookup_meaning('YES_NO',(hruserdt.get_table_value(p_business_group_id ,'FR_APEC_AGIRC','AGIRC',entry_information1,p_actual_termination_date)))
221: From
222: pay_element_entries_f peef ,
223: pay_element_links_f pel ,
224: pay_element_types_f pet
225: Where peef.assignment_id = p_assignment_id
226: and peef.element_link_id = pel.element_link_id
227: and pel.element_type_id = pet.element_type_id
228: and pet.element_name = 'FR_PENSION'

Line 299: pay_element_types_f pet ,

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,
303: pay_run_result_values prrv

Line 336: pay_element_types_f pet ,

332: Cursor csr_get_ft_indemnity Is
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,