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_SG_IRAS_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 657: from per_people_extra_info pae

653: nvl(pei_information18,l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
654: nvl(pei_information19,l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
655: nvl(pei_information20,l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533
656: nvl(pei_information21,l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534
657: from per_people_extra_info pae
658: where person_id = p_person_id
659: and information_type = 'HR_A8A_BENEFITS_IN_KIND_SG'
660: and pei_information1 = g_basis_year;
661: --

Line 688: from per_people_extra_info pae

684: nvl(pei_information23,l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
685: nvl(pei_information24,l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
686: nvl(pei_information25,l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523
687: nvl(pei_information26,l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524
688: from per_people_extra_info pae
689: where person_id = p_person_id
690: and information_type ='HR_A8A_FURN_EXP_SG'
691: and pei_information1 = g_basis_year;
692: --

Line 709: from per_people_extra_info pae

705: nvl(pei_information13,l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
706: nvl(pei_information14,l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
707: nvl(pei_information15,l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505
708: , nvl(pei_information16,l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088
709: from per_people_extra_info pae
710: where person_id = p_person_id
711: and information_type ='HR_A8A_HOTEL_ACCOM_SG'
712: and pei_information1 = g_basis_year;
713: --

Line 3153: v_section_45_applicable per_people_extra_info.pei_information1%type;

3149: p_basis_start in date,
3150: p_basis_end in date )
3151: is
3152: --
3153: v_section_45_applicable per_people_extra_info.pei_information1%type;
3154: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3155: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3156: v_exempt_remission per_people_extra_info.pei_information4%type;
3157: v_iras_approval per_people_extra_info.pei_information5%type;

Line 3154: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;

3150: p_basis_end in date )
3151: is
3152: --
3153: v_section_45_applicable per_people_extra_info.pei_information1%type;
3154: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3155: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3156: v_exempt_remission per_people_extra_info.pei_information4%type;
3157: v_iras_approval per_people_extra_info.pei_information5%type;
3158: v_approval_date per_people_extra_info.pei_information6%type;

Line 3155: v_ir8s_applicable per_people_extra_info.pei_information3%type;

3151: is
3152: --
3153: v_section_45_applicable per_people_extra_info.pei_information1%type;
3154: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3155: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3156: v_exempt_remission per_people_extra_info.pei_information4%type;
3157: v_iras_approval per_people_extra_info.pei_information5%type;
3158: v_approval_date per_people_extra_info.pei_information6%type;
3159: v_retirement_fund per_people_extra_info.pei_information3%type;

Line 3156: v_exempt_remission per_people_extra_info.pei_information4%type;

3152: --
3153: v_section_45_applicable per_people_extra_info.pei_information1%type;
3154: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3155: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3156: v_exempt_remission per_people_extra_info.pei_information4%type;
3157: v_iras_approval per_people_extra_info.pei_information5%type;
3158: v_approval_date per_people_extra_info.pei_information6%type;
3159: v_retirement_fund per_people_extra_info.pei_information3%type;
3160: v_designated_pension per_people_extra_info.pei_information4%type;

Line 3157: v_iras_approval per_people_extra_info.pei_information5%type;

3153: v_section_45_applicable per_people_extra_info.pei_information1%type;
3154: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3155: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3156: v_exempt_remission per_people_extra_info.pei_information4%type;
3157: v_iras_approval per_people_extra_info.pei_information5%type;
3158: v_approval_date per_people_extra_info.pei_information6%type;
3159: v_retirement_fund per_people_extra_info.pei_information3%type;
3160: v_designated_pension per_people_extra_info.pei_information4%type;
3161: -- Added for bug 5435088

Line 3158: v_approval_date per_people_extra_info.pei_information6%type;

3154: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3155: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3156: v_exempt_remission per_people_extra_info.pei_information4%type;
3157: v_iras_approval per_people_extra_info.pei_information5%type;
3158: v_approval_date per_people_extra_info.pei_information6%type;
3159: v_retirement_fund per_people_extra_info.pei_information3%type;
3160: v_designated_pension per_people_extra_info.pei_information4%type;
3161: -- Added for bug 5435088
3162: v_name_of_bank per_people_extra_info.pei_information6%type;

Line 3159: v_retirement_fund per_people_extra_info.pei_information3%type;

3155: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3156: v_exempt_remission per_people_extra_info.pei_information4%type;
3157: v_iras_approval per_people_extra_info.pei_information5%type;
3158: v_approval_date per_people_extra_info.pei_information6%type;
3159: v_retirement_fund per_people_extra_info.pei_information3%type;
3160: v_designated_pension per_people_extra_info.pei_information4%type;
3161: -- Added for bug 5435088
3162: v_name_of_bank per_people_extra_info.pei_information6%type;
3163: v_additional_information per_people_extra_info.pei_information1%type;

Line 3160: v_designated_pension per_people_extra_info.pei_information4%type;

3156: v_exempt_remission per_people_extra_info.pei_information4%type;
3157: v_iras_approval per_people_extra_info.pei_information5%type;
3158: v_approval_date per_people_extra_info.pei_information6%type;
3159: v_retirement_fund per_people_extra_info.pei_information3%type;
3160: v_designated_pension per_people_extra_info.pei_information4%type;
3161: -- Added for bug 5435088
3162: v_name_of_bank per_people_extra_info.pei_information6%type;
3163: v_additional_information per_people_extra_info.pei_information1%type;
3164: ---------------------------------------------------------------------------

Line 3162: v_name_of_bank per_people_extra_info.pei_information6%type;

3158: v_approval_date per_people_extra_info.pei_information6%type;
3159: v_retirement_fund per_people_extra_info.pei_information3%type;
3160: v_designated_pension per_people_extra_info.pei_information4%type;
3161: -- Added for bug 5435088
3162: v_name_of_bank per_people_extra_info.pei_information6%type;
3163: v_additional_information per_people_extra_info.pei_information1%type;
3164: ---------------------------------------------------------------------------
3165: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f
3166: -- Bug 5435088, Removed archiving gratuity_or_comp_info, gains_or_profit_from

Line 3163: v_additional_information per_people_extra_info.pei_information1%type;

3159: v_retirement_fund per_people_extra_info.pei_information3%type;
3160: v_designated_pension per_people_extra_info.pei_information4%type;
3161: -- Added for bug 5435088
3162: v_name_of_bank per_people_extra_info.pei_information6%type;
3163: v_additional_information per_people_extra_info.pei_information1%type;
3164: ---------------------------------------------------------------------------
3165: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f
3166: -- Bug 5435088, Removed archiving gratuity_or_comp_info, gains_or_profit_from
3167: -- _shares, remarks

Line 3185: from per_people_extra_info indicators,

3181: details.pei_information3,
3182: details.pei_information4,
3183: details.pei_information6, -- Name of bank
3184: info.pei_information1
3185: from per_people_extra_info indicators,
3186: per_people_extra_info info,
3187: per_people_extra_info details,
3188: per_people_f people
3189: where people.person_id = c_person_id

Line 3186: per_people_extra_info info,

3182: details.pei_information4,
3183: details.pei_information6, -- Name of bank
3184: info.pei_information1
3185: from per_people_extra_info indicators,
3186: per_people_extra_info info,
3187: per_people_extra_info details,
3188: per_people_f people
3189: where people.person_id = c_person_id
3190: and people.effective_start_date = (

Line 3187: per_people_extra_info details,

3183: details.pei_information6, -- Name of bank
3184: info.pei_information1
3185: from per_people_extra_info indicators,
3186: per_people_extra_info info,
3187: per_people_extra_info details,
3188: per_people_f people
3189: where people.person_id = c_person_id
3190: and people.effective_start_date = (
3191: select max(people1.effective_start_date)

Line 3859: -- bug 3501956 - Changed cursor to select information from per_people_extra_info table

3855:
3856: ---------------------------------------------------------------------------
3857: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
3858: -- bug 2691877
3859: -- bug 3501956 - Changed cursor to select information from per_people_extra_info table
3860: -- Bug 4314453 - Modified the cursor to use the table instead of view
3861: -- Bug 5435088 - Added grant type
3862: ---------------------------------------------------------------------------
3863: cursor shares_details

Line 3884: per_people_extra_info pei,

3880: decode(pei2.pei_information3, null, null, to_char(fnd_date.canonical_to_date(pei2.pei_information3),'YYYY')||'/'||
3881: to_char(fnd_date.canonical_to_date(pei2.pei_information3),'MM')||'/'||to_char(fnd_date.canonical_to_date(pei2.pei_information3),'DD')) grant_date,
3882: pei2.pei_information4 shares_granted
3883: from per_all_people_f pap,
3884: per_people_extra_info pei,
3885: per_people_extra_info pei2,
3886: hr_all_organization_units hou,
3887: hr_organization_information hoi2,
3888: hr_organization_information hoi1

Line 3885: per_people_extra_info pei2,

3881: to_char(fnd_date.canonical_to_date(pei2.pei_information3),'MM')||'/'||to_char(fnd_date.canonical_to_date(pei2.pei_information3),'DD')) grant_date,
3882: pei2.pei_information4 shares_granted
3883: from per_all_people_f pap,
3884: per_people_extra_info pei,
3885: per_people_extra_info pei2,
3886: hr_all_organization_units hou,
3887: hr_organization_information hoi2,
3888: hr_organization_information hoi1
3889: where pap.person_id = c_person_id