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 665: from per_people_extra_info pae

661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
663: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533
664: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534
665: from per_people_extra_info pae
666: where person_id = p_person_id
667: and information_type = 'HR_A8A_BENEFITS_IN_KIND_SG'
668: and pei_information1 = g_basis_year;
669: --

Line 697: from per_people_extra_info pae

693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
695: nvl(fnd_number.canonical_to_number(pei_information25),l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523
696: nvl(fnd_number.canonical_to_number(pei_information26),l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524
697: from per_people_extra_info pae
698: where person_id = p_person_id
699: and information_type ='HR_A8A_FURN_EXP_SG'
700: and pei_information1 = g_basis_year;
701: --

Line 719: from per_people_extra_info pae

715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
717: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505
718: , nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088
719: from per_people_extra_info pae
720: where person_id = p_person_id
721: and information_type ='HR_A8A_HOTEL_ACCOM_SG'
722: and pei_information1 = g_basis_year;
723: --

Line 2576: per_people_extra_info pei,

2572: is
2573: select
2574: count(distinct pei.person_extra_info_id)
2575: from per_all_people_f pap,
2576: per_people_extra_info pei,
2577: per_assignments_f assign,
2578: hr_soft_coding_keyflex hsc
2579: where pap.person_id = pei.person_id
2580: and pei.information_type = 'HR_STOCK_EXERCISE_SG'

Line 3285: v_section_45_applicable per_people_extra_info.pei_information1%type;

3281: p_basis_start in date,
3282: p_basis_end in date )
3283: is
3284: --
3285: v_section_45_applicable per_people_extra_info.pei_information1%type;
3286: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3287: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3288: v_exempt_remission per_people_extra_info.pei_information4%type;
3289: v_iras_approval per_people_extra_info.pei_information5%type;

Line 3286: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;

3282: p_basis_end in date )
3283: is
3284: --
3285: v_section_45_applicable per_people_extra_info.pei_information1%type;
3286: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3287: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3288: v_exempt_remission per_people_extra_info.pei_information4%type;
3289: v_iras_approval per_people_extra_info.pei_information5%type;
3290: v_approval_date per_people_extra_info.pei_information6%type;

Line 3287: v_ir8s_applicable per_people_extra_info.pei_information3%type;

3283: is
3284: --
3285: v_section_45_applicable per_people_extra_info.pei_information1%type;
3286: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3287: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3288: v_exempt_remission per_people_extra_info.pei_information4%type;
3289: v_iras_approval per_people_extra_info.pei_information5%type;
3290: v_approval_date per_people_extra_info.pei_information6%type;
3291: v_retirement_fund per_people_extra_info.pei_information3%type;

Line 3288: v_exempt_remission per_people_extra_info.pei_information4%type;

3284: --
3285: v_section_45_applicable per_people_extra_info.pei_information1%type;
3286: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3287: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3288: v_exempt_remission per_people_extra_info.pei_information4%type;
3289: v_iras_approval per_people_extra_info.pei_information5%type;
3290: v_approval_date per_people_extra_info.pei_information6%type;
3291: v_retirement_fund per_people_extra_info.pei_information3%type;
3292: v_designated_pension per_people_extra_info.pei_information4%type;

Line 3289: v_iras_approval per_people_extra_info.pei_information5%type;

3285: v_section_45_applicable per_people_extra_info.pei_information1%type;
3286: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3287: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3288: v_exempt_remission per_people_extra_info.pei_information4%type;
3289: v_iras_approval per_people_extra_info.pei_information5%type;
3290: v_approval_date per_people_extra_info.pei_information6%type;
3291: v_retirement_fund per_people_extra_info.pei_information3%type;
3292: v_designated_pension per_people_extra_info.pei_information4%type;
3293: -- Added for bug 5435088

Line 3290: v_approval_date per_people_extra_info.pei_information6%type;

3286: v_income_tax_borne_by_employer per_people_extra_info.pei_information2%type;
3287: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3288: v_exempt_remission per_people_extra_info.pei_information4%type;
3289: v_iras_approval per_people_extra_info.pei_information5%type;
3290: v_approval_date per_people_extra_info.pei_information6%type;
3291: v_retirement_fund per_people_extra_info.pei_information3%type;
3292: v_designated_pension per_people_extra_info.pei_information4%type;
3293: -- Added for bug 5435088
3294: v_name_of_bank per_people_extra_info.pei_information6%type;

Line 3291: v_retirement_fund per_people_extra_info.pei_information3%type;

3287: v_ir8s_applicable per_people_extra_info.pei_information3%type;
3288: v_exempt_remission per_people_extra_info.pei_information4%type;
3289: v_iras_approval per_people_extra_info.pei_information5%type;
3290: v_approval_date per_people_extra_info.pei_information6%type;
3291: v_retirement_fund per_people_extra_info.pei_information3%type;
3292: v_designated_pension per_people_extra_info.pei_information4%type;
3293: -- Added for bug 5435088
3294: v_name_of_bank per_people_extra_info.pei_information6%type;
3295: v_additional_information per_people_extra_info.pei_information1%type;

Line 3292: v_designated_pension per_people_extra_info.pei_information4%type;

3288: v_exempt_remission per_people_extra_info.pei_information4%type;
3289: v_iras_approval per_people_extra_info.pei_information5%type;
3290: v_approval_date per_people_extra_info.pei_information6%type;
3291: v_retirement_fund per_people_extra_info.pei_information3%type;
3292: v_designated_pension per_people_extra_info.pei_information4%type;
3293: -- Added for bug 5435088
3294: v_name_of_bank per_people_extra_info.pei_information6%type;
3295: v_additional_information per_people_extra_info.pei_information1%type;
3296: ---------------------------------------------------------------------------

Line 3294: v_name_of_bank per_people_extra_info.pei_information6%type;

3290: v_approval_date per_people_extra_info.pei_information6%type;
3291: v_retirement_fund per_people_extra_info.pei_information3%type;
3292: v_designated_pension per_people_extra_info.pei_information4%type;
3293: -- Added for bug 5435088
3294: v_name_of_bank per_people_extra_info.pei_information6%type;
3295: v_additional_information per_people_extra_info.pei_information1%type;
3296: ---------------------------------------------------------------------------
3297: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f
3298: -- Bug 5435088, Removed archiving gratuity_or_comp_info, gains_or_profit_from

Line 3295: v_additional_information per_people_extra_info.pei_information1%type;

3291: v_retirement_fund per_people_extra_info.pei_information3%type;
3292: v_designated_pension per_people_extra_info.pei_information4%type;
3293: -- Added for bug 5435088
3294: v_name_of_bank per_people_extra_info.pei_information6%type;
3295: v_additional_information per_people_extra_info.pei_information1%type;
3296: ---------------------------------------------------------------------------
3297: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f
3298: -- Bug 5435088, Removed archiving gratuity_or_comp_info, gains_or_profit_from
3299: -- _shares, remarks

Line 3317: from per_people_extra_info indicators,

3313: details.pei_information3,
3314: details.pei_information4,
3315: details.pei_information6, -- Name of bank
3316: info.pei_information1
3317: from per_people_extra_info indicators,
3318: per_people_extra_info info,
3319: per_people_extra_info details,
3320: per_people_f people
3321: where people.person_id = c_person_id

Line 3318: per_people_extra_info info,

3314: details.pei_information4,
3315: details.pei_information6, -- Name of bank
3316: info.pei_information1
3317: from per_people_extra_info indicators,
3318: per_people_extra_info info,
3319: per_people_extra_info details,
3320: per_people_f people
3321: where people.person_id = c_person_id
3322: and people.effective_start_date = (

Line 3319: per_people_extra_info details,

3315: details.pei_information6, -- Name of bank
3316: info.pei_information1
3317: from per_people_extra_info indicators,
3318: per_people_extra_info info,
3319: per_people_extra_info details,
3320: per_people_f people
3321: where people.person_id = c_person_id
3322: and people.effective_start_date = (
3323: select max(people1.effective_start_date)

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

3999:
4000: ---------------------------------------------------------------------------
4001: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
4002: -- bug 2691877
4003: -- bug 3501956 - Changed cursor to select information from per_people_extra_info table
4004: -- Bug 4314453 - Modified the cursor to use the table instead of view
4005: -- Bug 5435088 - Added grant type
4006: -- Bug 13069992 - Added new function to check ESOP date
4007: ---------------------------------------------------------------------------

Line 4029: per_people_extra_info pei,

4025: decode(pei2.pei_information3, null, null, to_char(fnd_date.canonical_to_date(pei2.pei_information3),'YYYY')||'/'||
4026: to_char(fnd_date.canonical_to_date(pei2.pei_information3),'MM')||'/'||to_char(fnd_date.canonical_to_date(pei2.pei_information3),'DD')) grant_date,
4027: fnd_number.canonical_to_number(pei2.pei_information4) shares_granted
4028: from per_all_people_f pap,
4029: per_people_extra_info pei,
4030: per_people_extra_info pei2,
4031: hr_all_organization_units hou,
4032: hr_organization_information hoi2,
4033: hr_organization_information hoi1

Line 4030: per_people_extra_info pei2,

4026: to_char(fnd_date.canonical_to_date(pei2.pei_information3),'MM')||'/'||to_char(fnd_date.canonical_to_date(pei2.pei_information3),'DD')) grant_date,
4027: fnd_number.canonical_to_number(pei2.pei_information4) shares_granted
4028: from per_all_people_f pap,
4029: per_people_extra_info pei,
4030: per_people_extra_info pei2,
4031: hr_all_organization_units hou,
4032: hr_organization_information hoi2,
4033: hr_organization_information hoi1
4034: where pap.person_id = c_person_id