DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP202 dependencies on PER_ALL_ASSIGNMENTS_F

Line 187: per_all_assignments_f paaf

183: ,peef.effective_start_date absence_start_date
184: ,peef.effective_end_date absence_end_date
185: ,paaf.payroll_id payroll_id
186: FROM
187: per_all_assignments_f paaf
188: ,pay_element_types_f petf
189: ,pay_element_entries_f peef
190: WHERE
191: paaf.person_id = p_person_id

Line 221: per_all_assignments_f paaf

217: ,DECODE(hl.postal_code,NULL,' ',','||substr(hl.postal_code,1,5)) le_postalcode
218: ,SUBSTR (p_le_phone_number,1,30) le_phone
219: ,substr(p_le_email_addr,1,30) le_email
220: FROM
221: per_all_assignments_f paaf
222: ,hr_soft_coding_keyflex hsck
223: ,hr_all_organization_units haou
224: ,hr_locations hl
225: WHERE