APPS.PAY_GB_MOVDED_EDI dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 49: on the per_assignment_extra_info table

45: assignment table with period of service
46: table based on period_of_service_id column.
47: 16-JUN-2006 KTHAMPAN 115.9 Code change for EDI Rollback.
48: 23-JUN-2006 KTHAMPAN 115.10 Not to create asg action if no rows is found
49: on the per_assignment_extra_info table
50: (internal_action_creation)
51: 29-JUN-2006 KTHAMPAN 115.11 Fix gscc error.
52: 16-AUG-2006 TUKUMAR 115.12 Bug 5469122 : changed csr_student_loan in
53: function fetch_p45_3_rec

Line 236: per_assignment_extra_info aei

232: select aei.assignment_extra_info_id,
233: aei.object_version_number,
234: aei.aei_information1
235: from pay_assignment_actions paa,
236: per_assignment_extra_info aei
237: where paa.assignment_action_id = p_assact
238: and aei.assignment_id = paa.assignment_id
239: and aei.information_type = p_type;
240:

Line 319: from per_assignment_extra_info

315: select aei_information1,
316: decode(p_info_type,'GB_P45_3', aei_information8
317: ,'GB_P46PENNOT', aei_information4
318: ,'GB_P46', aei_information3)
319: from per_assignment_extra_info
320: where assignment_id = p_assignment_id
321: and information_type = p_info_type;
322:
323: cursor csr_p46_5_default(p_assignment_id number) is /*** open this cursor only for rep_type=P46_5 ***/

Line 326: from per_assignment_extra_info

322:
323: cursor csr_p46_5_default(p_assignment_id number) is /*** open this cursor only for rep_type=P46_5 ***/
324: select aei_information5,
325: aei_information6
326: from per_assignment_extra_info
327: where assignment_id = p_assignment_id
328: and information_type = p_info_type;
329:
330: cursor csr_p46_5_def_det(p_assignment_id number,default_archive varchar2)

Line 497: from per_assignment_extra_info aei

493: aei.aei_information9 prev_last_pay_period_type,
494: aei.aei_information10 prev_last_pay_period,
495: aei.aei_information11 recently_bereaved,
496: aei.object_version_number
497: from per_assignment_extra_info aei
498: where aei.assignment_id = p_person_rec.assignment_id
499: and aei.information_type = p_info_type;
500:
501:

Line 1034: from per_assignment_extra_info aei

1030: /*changes for P45PT_3 start*/
1031: --Bug 6994632 fetching Prev Tax Pay Notified value
1032: aei.aei_information12 prev_tax_pay_notified,
1033: aei.object_version_number
1034: from per_assignment_extra_info aei
1035: where aei.assignment_id = p_person_rec.assignment_id
1036: and aei.information_type = 'GB_P45_3';
1037:
1038: cursor csr_student_loan is

Line 1201: from per_assignment_extra_info aei

1197: aei.aei_information2 p46_statement,
1198: aei.aei_information3 static_flag,
1199: aei.aei_information4 student_loan,
1200: aei.object_version_number
1201: from per_assignment_extra_info aei
1202: where aei.assignment_id = p_person_rec.assignment_id
1203: and aei.information_type = 'GB_P46';
1204:
1205: l_p46_rec csr_p46_details%rowtype;

Line 1271: from per_assignment_extra_info aei

1267: aei.aei_information4 student_loan,
1268: aei.aei_information5 default_send_edi,
1269: aei.aei_information6 default_static_edi,
1270: aei.object_version_number
1271: from per_assignment_extra_info aei
1272: where aei.assignment_id = p_person_rec.assignment_id
1273: and aei.information_type = 'GB_P46';
1274:
1275: cursor csr_p46_5_def_det

Line 1381: from per_assignment_extra_info aei

1377: aei.aei_information2 annual_pension,
1378: aei.aei_information3 date_pension_start,
1379: aei.aei_information4 static_flag,
1380: aei.object_version_number
1381: from per_assignment_extra_info aei
1382: where aei.assignment_id = p_person_rec.assignment_id
1383: and aei.information_type = 'GB_P46PENNOT';
1384:
1385: l_p46p_rec csr_p46p_details%rowtype;