DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 3187: from per_assignment_extra_info

3183: select aei_information1,
3184: aei_information2,
3185: aei_information3,
3186: aei_information4
3187: from per_assignment_extra_info
3188: where information_type = 'PAY_US_PENSION_REPORTING'
3189: and assignment_id = cp_assignment_id;
3190:
3191: CURSOR c_get_1099_distribution_info(cp_person_id in number,

Line 3225: from per_assignment_extra_info

3221: /* This cursor is removed because now the NJ Disablily Plan ID will be stored in segment19 of
3222: Soft Coded KFF.
3223: CURSOR c_get_disability_plan_eit_info(cp_assignment_id in number) IS
3224: select aei_information1
3225: from per_assignment_extra_info
3226: where information_type = 'PAY_US_DISABILITY_PLAN_INFO'
3227: and assignment_id = cp_assignment_id;
3228: */
3229: