APPS.PAY_ZA_EOY_VAL dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 770: per_assignment_extra_info paei,

766: trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))) value
767: FROM pay_za_irp5_bal_codes irp5,
768: ff_archive_items arc,
769: ff_database_items dbi,
770: per_assignment_extra_info paei,
771: pay_assignment_actions paa
772: WHERE dbi.user_name in
773: (
774: 'A_ANNUAL_ASSET_PURCHASED_AT_REDUCED_VALUE_PKG_ASG_TAX_YTD',

Line 3244: per_assignment_extra_info aei

3240: where haou.organization_id=ass.organization_id) org_location_id
3241: from
3242: per_assignments_f ass,
3243: per_all_people_f per,
3244: per_assignment_extra_info aei
3245: where
3246: ass.payroll_id = nvl(:1,ass.payroll_id)
3247: and ass.business_group_id=:2
3248: and aei.assignment_id(+)=ass.assignment_id

Line 4132: per_assignment_extra_info paei

4128: CURSOR fetch_pkg_balances( p_asgn_action_id pay_assignment_actions.assignment_action_id%type
4129: , p_cert_num varchar2 ) IS
4130: select '1' flag
4131: FROM pay_action_information pai,
4132: per_assignment_extra_info paei
4133: where pai.action_context_id = p_asgn_action_id
4134: and paei.assignment_id = pai.assignment_id
4135: AND paei.AEI_INFORMATION8 <> '1' -- 'Pension Basis:1 is Fixed Percentage of Specific Income
4136: AND paei.information_type = 'ZA_SPECIFIC_INFO'