APPS.PAY_HK_IR56_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 448: per_assignment_extra_info paei,

444: per_assignments_f paaf,
445: fnd_territories_tl ftv, /* Bug No : 3059915 */
446: per_contact_relationships pcr,
447: per_addresses pad,
448: per_assignment_extra_info paei,
449: per_periods_of_service pps,
450: hr_soft_coding_keyflex hsck,
451: hr_lookups hrl
452: WHERE paaf.person_id = papf.person_id

Line 497: from per_assignment_extra_info paei

493: SELECT DISTINCT
494: substr(paei.aei_information2,1,10) last_run_date,
495: paei.aei_information5 last_run_type
496:
497: from per_assignment_extra_info paei
498:
499: where paei.aei_information_category = 'HR_IR56B_REPORTING_INFO_HK'
500: AND to_number(paei.assignment_id) = c_assignment_id
501: AND to_number(paei.aei_information1) = c_reporting_year;

Line 512: FROM per_assignment_extra_info paei,

508: CURSOR ir56f_report_date
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