APPS.PAY_HK_IR56_ARCHIVE dependencies on PER_ASSIGNMENT_INFO_TYPES

Line 513: per_assignment_info_types pait

509: (c_assignment_id pay_assignment_actions.assignment_id%TYPE)
510: IS
511: SELECT TO_CHAR(to_date(paei.aei_information2,'yyyy/mm/dd hh24:mi:ss'),'yyyy/mm/dd')
512: FROM per_assignment_extra_info paei,
513: per_assignment_info_types pait
514: WHERE paei.assignment_id = c_assignment_id
515: AND paei.information_type = 'HR_LE_REPORTING_HK'
516: AND paei.information_type = pait.information_type
517: AND pait.active_inactive_flag = 'Y';