DBA Data[Home] [Help]

APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on PAY_ELEMENT_LINKS_F

Line 141: pay_element_links_f pel ,

137: Select
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

Line 223: pay_element_links_f pel ,

219: Cursor stat_cadre Is
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