eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 304: per_assignment_extra_info aei

300: select aei.assignment_extra_info_id,
301: aei.object_version_number,
302: aei.aei_information1
303: from pay_assignment_actions paa,
304: per_assignment_extra_info aei
305: where paa.assignment_action_id = p_assact
306: and aei.assignment_id = paa.assignment_id
307: and aei.information_type = p_type;
308:

Line 389: from per_assignment_extra_info

385: decode(p_info_type,'GB_P45_3', aei_information8
386: ,'GB_P46PENNOT', aei_information4
387: ,'GB_P46', aei_information3
388: ,'GB_P46EXP', aei_information3 ) --Added for P46EXP_Ver6 Changes
389: from per_assignment_extra_info
390: where assignment_id = p_assignment_id
391: and information_type = p_info_type;
392:
393: cursor csr_p46_5_default(p_assignment_id number) is /*** open this cursor only for rep_type=P46_5 ***/

Line 396: from per_assignment_extra_info

392:
393: cursor csr_p46_5_default(p_assignment_id number) is /*** open this cursor only for rep_type=P46_5 ***/
394: select aei_information5,
395: aei_information6
396: from per_assignment_extra_info
397: where assignment_id = p_assignment_id
398: and information_type = p_info_type;
399:
400: cursor csr_p46_5_def_det(p_assignment_id number,default_archive varchar2)

Line 687: from per_assignment_extra_info aei

683: aei.aei_information9 prev_last_pay_period_type,
684: aei.aei_information10 prev_last_pay_period,
685: aei.aei_information11 recently_bereaved,
686: aei.object_version_number
687: from per_assignment_extra_info aei
688: where aei.assignment_id = p_person_rec.assignment_id
689: and aei.information_type = p_info_type;
690:
691:

Line 1235: from per_assignment_extra_info aei

1231: /*changes for P45PT_3 start*/
1232: --Bug 6994632 fetching Prev Tax Pay Notified value
1233: aei.aei_information12 prev_tax_pay_notified,
1234: aei.object_version_number
1235: from per_assignment_extra_info aei
1236: where aei.assignment_id = p_person_rec.assignment_id
1237: and aei.information_type = 'GB_P45_3';
1238:
1239: cursor csr_student_loan is

Line 1402: from per_assignment_extra_info aei

1398: aei.aei_information2 p46_statement,
1399: aei.aei_information3 static_flag,
1400: aei.aei_information4 student_loan,
1401: aei.object_version_number
1402: from per_assignment_extra_info aei
1403: where aei.assignment_id = p_person_rec.assignment_id
1404: and aei.information_type = 'GB_P46';
1405:
1406: l_p46_rec csr_p46_details%rowtype;

Line 1473: from per_assignment_extra_info aei

1469: aei.object_version_number,
1470: aei.aei_information5 eea_cw_citizen,
1471: aei.aei_information6 em6_scheme,
1472: aei.aei_information7 date_started_uk
1473: from per_assignment_extra_info aei
1474: where aei.assignment_id = p_person_rec.assignment_id
1475: and aei.information_type = 'GB_P46EXP';
1476:
1477: l_p46_rec csr_p46_details%rowtype;

Line 1589: l_p46_expat_statement per_assignment_extra_info.aei_information2%TYPE;

1585: l_tax_basis_in_use varchar2(100);
1586: l_msg_value varchar2(100);
1587: l_eff_date date;
1588:
1589: l_p46_expat_statement per_assignment_extra_info.aei_information2%TYPE;
1590: l_p46_expat_start_empl_date per_assignment_extra_info.aei_information7%TYPE;
1591: l_p46_expat_eea_citizen per_assignment_extra_info.aei_information5%TYPE;
1592:
1593: BEGIN

Line 1590: l_p46_expat_start_empl_date per_assignment_extra_info.aei_information7%TYPE;

1586: l_msg_value varchar2(100);
1587: l_eff_date date;
1588:
1589: l_p46_expat_statement per_assignment_extra_info.aei_information2%TYPE;
1590: l_p46_expat_start_empl_date per_assignment_extra_info.aei_information7%TYPE;
1591: l_p46_expat_eea_citizen per_assignment_extra_info.aei_information5%TYPE;
1592:
1593: BEGIN
1594: l_sex := p_tab_rec_data(0).act_info17;

Line 1591: l_p46_expat_eea_citizen per_assignment_extra_info.aei_information5%TYPE;

1587: l_eff_date date;
1588:
1589: l_p46_expat_statement per_assignment_extra_info.aei_information2%TYPE;
1590: l_p46_expat_start_empl_date per_assignment_extra_info.aei_information7%TYPE;
1591: l_p46_expat_eea_citizen per_assignment_extra_info.aei_information5%TYPE;
1592:
1593: BEGIN
1594: l_sex := p_tab_rec_data(0).act_info17;
1595: hr_utility.set_location('Etext41 l_sex'||l_sex,111);

Line 2050: from per_assignment_extra_info aei

2046: aei.aei_information4 student_loan,
2047: aei.aei_information5 default_send_edi,
2048: aei.aei_information6 default_static_edi,
2049: aei.object_version_number
2050: from per_assignment_extra_info aei
2051: where aei.assignment_id = p_person_rec.assignment_id
2052: and aei.information_type = 'GB_P46';
2053:
2054: cursor csr_p46_5_def_det

Line 2160: from per_assignment_extra_info aei

2156: aei.aei_information2 annual_pension,
2157: aei.aei_information3 date_pension_start,
2158: aei.aei_information4 static_flag,
2159: aei.object_version_number
2160: from per_assignment_extra_info aei
2161: where aei.assignment_id = p_person_rec.assignment_id
2162: and aei.information_type = 'GB_P46PENNOT';
2163:
2164: l_p46p_rec csr_p46p_details%rowtype;