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

Line 462: from per_people_extra_info pae

458: nvl(pei_information18,l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
459: nvl(pei_information19,l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
460: nvl(pei_information20,l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533
461: nvl(pei_information21,l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534
462: from per_people_extra_info pae
463: where person_id = p_person_id
464: and information_type = 'HR_A8A_BENEFITS_IN_KIND_SG'
465: and pei_information1 = g_basis_year;
466: --

Line 493: from per_people_extra_info pae

489: nvl(pei_information23,l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
490: nvl(pei_information24,l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
491: nvl(pei_information25,l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523
492: nvl(pei_information26,l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524
493: from per_people_extra_info pae
494: where person_id = p_person_id
495: and information_type ='HR_A8A_FURN_EXP_SG'
496: and pei_information1 = g_basis_year;
497: --

Line 514: from per_people_extra_info pae

510: nvl(pei_information13,l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
511: nvl(pei_information14,l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
512: nvl(pei_information15,l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505
513: , nvl(pei_information16,l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088
514: from per_people_extra_info pae
515: where person_id = p_person_id
516: and information_type ='HR_A8A_HOTEL_ACCOM_SG'
517: and pei_information1 = g_basis_year;
518: --

Line 2240: ( person_extra_info_id per_people_extra_info.person_extra_info_id%type,

2236: type t_assignment_extra_info_tab is table of per_assignment_extra_info.assignment_extra_info_id%TYPE index by binary_integer;
2237: t_aeid_a8b t_assignment_extra_info_tab;
2238:
2239: type shares_amend_rec is record
2240: ( person_extra_info_id per_people_extra_info.person_extra_info_id%type,
2241: stock_option per_people_extra_info.pei_information1%type,
2242: exercise_price per_people_extra_info.pei_information1%type,
2243: market_exercise_value per_people_extra_info.pei_information1%type,
2244: exercise_date per_people_extra_info.pei_information1%type,

Line 2241: stock_option per_people_extra_info.pei_information1%type,

2237: t_aeid_a8b t_assignment_extra_info_tab;
2238:
2239: type shares_amend_rec is record
2240: ( person_extra_info_id per_people_extra_info.person_extra_info_id%type,
2241: stock_option per_people_extra_info.pei_information1%type,
2242: exercise_price per_people_extra_info.pei_information1%type,
2243: market_exercise_value per_people_extra_info.pei_information1%type,
2244: exercise_date per_people_extra_info.pei_information1%type,
2245: shares_acquired per_people_extra_info.pei_information1%type,

Line 2242: exercise_price per_people_extra_info.pei_information1%type,

2238:
2239: type shares_amend_rec is record
2240: ( person_extra_info_id per_people_extra_info.person_extra_info_id%type,
2241: stock_option per_people_extra_info.pei_information1%type,
2242: exercise_price per_people_extra_info.pei_information1%type,
2243: market_exercise_value per_people_extra_info.pei_information1%type,
2244: exercise_date per_people_extra_info.pei_information1%type,
2245: shares_acquired per_people_extra_info.pei_information1%type,
2246: name_of_company per_people_extra_info.pei_information1%type,

Line 2243: market_exercise_value per_people_extra_info.pei_information1%type,

2239: type shares_amend_rec is record
2240: ( person_extra_info_id per_people_extra_info.person_extra_info_id%type,
2241: stock_option per_people_extra_info.pei_information1%type,
2242: exercise_price per_people_extra_info.pei_information1%type,
2243: market_exercise_value per_people_extra_info.pei_information1%type,
2244: exercise_date per_people_extra_info.pei_information1%type,
2245: shares_acquired per_people_extra_info.pei_information1%type,
2246: name_of_company per_people_extra_info.pei_information1%type,
2247: rcb per_people_extra_info.pei_information1%type,

Line 2244: exercise_date per_people_extra_info.pei_information1%type,

2240: ( person_extra_info_id per_people_extra_info.person_extra_info_id%type,
2241: stock_option per_people_extra_info.pei_information1%type,
2242: exercise_price per_people_extra_info.pei_information1%type,
2243: market_exercise_value per_people_extra_info.pei_information1%type,
2244: exercise_date per_people_extra_info.pei_information1%type,
2245: shares_acquired per_people_extra_info.pei_information1%type,
2246: name_of_company per_people_extra_info.pei_information1%type,
2247: rcb per_people_extra_info.pei_information1%type,
2248: company_type per_people_extra_info.pei_information1%type,

Line 2245: shares_acquired per_people_extra_info.pei_information1%type,

2241: stock_option per_people_extra_info.pei_information1%type,
2242: exercise_price per_people_extra_info.pei_information1%type,
2243: market_exercise_value per_people_extra_info.pei_information1%type,
2244: exercise_date per_people_extra_info.pei_information1%type,
2245: shares_acquired per_people_extra_info.pei_information1%type,
2246: name_of_company per_people_extra_info.pei_information1%type,
2247: rcb per_people_extra_info.pei_information1%type,
2248: company_type per_people_extra_info.pei_information1%type,
2249: market_grant_value per_people_extra_info.pei_information1%type,

Line 2246: name_of_company per_people_extra_info.pei_information1%type,

2242: exercise_price per_people_extra_info.pei_information1%type,
2243: market_exercise_value per_people_extra_info.pei_information1%type,
2244: exercise_date per_people_extra_info.pei_information1%type,
2245: shares_acquired per_people_extra_info.pei_information1%type,
2246: name_of_company per_people_extra_info.pei_information1%type,
2247: rcb per_people_extra_info.pei_information1%type,
2248: company_type per_people_extra_info.pei_information1%type,
2249: market_grant_value per_people_extra_info.pei_information1%type,
2250: grant_type per_people_extra_info.pei_information1%type,

Line 2247: rcb per_people_extra_info.pei_information1%type,

2243: market_exercise_value per_people_extra_info.pei_information1%type,
2244: exercise_date per_people_extra_info.pei_information1%type,
2245: shares_acquired per_people_extra_info.pei_information1%type,
2246: name_of_company per_people_extra_info.pei_information1%type,
2247: rcb per_people_extra_info.pei_information1%type,
2248: company_type per_people_extra_info.pei_information1%type,
2249: market_grant_value per_people_extra_info.pei_information1%type,
2250: grant_type per_people_extra_info.pei_information1%type,
2251: grant_date per_people_extra_info.pei_information1%type,

Line 2248: company_type per_people_extra_info.pei_information1%type,

2244: exercise_date per_people_extra_info.pei_information1%type,
2245: shares_acquired per_people_extra_info.pei_information1%type,
2246: name_of_company per_people_extra_info.pei_information1%type,
2247: rcb per_people_extra_info.pei_information1%type,
2248: company_type per_people_extra_info.pei_information1%type,
2249: market_grant_value per_people_extra_info.pei_information1%type,
2250: grant_type per_people_extra_info.pei_information1%type,
2251: grant_date per_people_extra_info.pei_information1%type,
2252: rec_type varchar2(1));

Line 2249: market_grant_value per_people_extra_info.pei_information1%type,

2245: shares_acquired per_people_extra_info.pei_information1%type,
2246: name_of_company per_people_extra_info.pei_information1%type,
2247: rcb per_people_extra_info.pei_information1%type,
2248: company_type per_people_extra_info.pei_information1%type,
2249: market_grant_value per_people_extra_info.pei_information1%type,
2250: grant_type per_people_extra_info.pei_information1%type,
2251: grant_date per_people_extra_info.pei_information1%type,
2252: rec_type varchar2(1));
2253: type shares_value_tab is table of shares_amend_rec index by binary_integer;

Line 2250: grant_type per_people_extra_info.pei_information1%type,

2246: name_of_company per_people_extra_info.pei_information1%type,
2247: rcb per_people_extra_info.pei_information1%type,
2248: company_type per_people_extra_info.pei_information1%type,
2249: market_grant_value per_people_extra_info.pei_information1%type,
2250: grant_type per_people_extra_info.pei_information1%type,
2251: grant_date per_people_extra_info.pei_information1%type,
2252: rec_type varchar2(1));
2253: type shares_value_tab is table of shares_amend_rec index by binary_integer;
2254: t_value_shares shares_value_tab;

Line 2251: grant_date per_people_extra_info.pei_information1%type,

2247: rcb per_people_extra_info.pei_information1%type,
2248: company_type per_people_extra_info.pei_information1%type,
2249: market_grant_value per_people_extra_info.pei_information1%type,
2250: grant_type per_people_extra_info.pei_information1%type,
2251: grant_date per_people_extra_info.pei_information1%type,
2252: rec_type varchar2(1));
2253: type shares_value_tab is table of shares_amend_rec index by binary_integer;
2254: t_value_shares shares_value_tab;
2255:

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

2289:
2290: ---------------------------------------------------------------------------
2291: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
2292: -- bug 2691877
2293: -- bug 3501956 - Changed cursor to select information from per_people_extra_info table
2294: -- Bug 4314453 - Modified the cursor to use the table instead of view
2295: -- Bug 5435088 - Added grant type
2296: ---------------------------------------------------------------------------
2297: cursor shares_details

Line 2318: per_people_extra_info pei,

2314: decode(pei2.pei_information3, null, null, to_char(fnd_date.canonical_to_date(pei2.pei_information3),'YYYY')||'/'||
2315: to_char(fnd_date.canonical_to_date(pei2.pei_information3),'MM')||'/'||to_char(fnd_date.canonical_to_date(pei2.pei_information3),'DD')) grant_date,
2316: pei2.pei_information4 shares_granted
2317: from per_all_people_f pap,
2318: per_people_extra_info pei,
2319: per_people_extra_info pei2,
2320: hr_all_organization_units hou,
2321: hr_organization_information hoi2,
2322: hr_organization_information hoi1

Line 2319: per_people_extra_info pei2,

2315: to_char(fnd_date.canonical_to_date(pei2.pei_information3),'MM')||'/'||to_char(fnd_date.canonical_to_date(pei2.pei_information3),'DD')) grant_date,
2316: pei2.pei_information4 shares_granted
2317: from per_all_people_f pap,
2318: per_people_extra_info pei,
2319: per_people_extra_info pei2,
2320: hr_all_organization_units hou,
2321: hr_organization_information hoi2,
2322: hr_organization_information hoi1
2323: where pap.person_id = c_person_id

Line 2370: from per_people_extra_info pei

2366: and con1.sequence_no =2)
2367: and arch.archive_item_id = con2.archive_item_id
2368: and con2.sequence_no = 3
2369: and not exists (select 1
2370: from per_people_extra_info pei
2371: where pei.person_id = c_person_id
2372: and pei.person_extra_info_id = con2.context);
2373: begin
2374: v_moa_305 := 0;