DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ER_RETURNS dependencies on PER_ALL_ASSIGNMENTS_F

Line 473: ,per_all_assignments_f paa

469:
470: CURSOR c_remarks IS
471: SELECT paei.aei_information2
472: FROM per_assignment_extra_info paei
473: ,per_all_assignments_f paa
474: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
475: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
476: AND paei.assignment_id = paa.assignment_id
477: AND paa.person_id = TO_NUMBER(p_person_id)