[Home] [Help]
68: upper(max(pai.action_information5)) asset_description,
69: pay_gb_p11d_magtape.get_description(pai.action_information6,'GB_ASSET_TYPE',
70: pai.action_information4) asset_type
71: from per_all_assignments_f paf,
72: pay_assignment_actions paa,
73: pay_action_information pai,
74: pay_action_information pai_person
75: where paf.person_id = p_person_id
76: and paf.effective_end_date = (select max(paf2.effective_end_date)
230: --UPPER(pai.action_information5) payment_description,
231: pay_gb_p11d_magtape.get_description(pai.action_information6,'GB_PAYMENTS_MADE',
232: pai.action_information4) payment_type
233: from per_all_assignments_f paf,
234: pay_assignment_actions paa,
235: pay_action_information pai,
236: pay_action_information pai_person
237: where paf.person_id = p_person_id
238: and paf.effective_end_date = (select max(paf2.effective_end_date)
353: sum(to_number(nvl(pai.action_information11,0))) cash_equivalent,
354: sum(to_number(nvl(pai.action_information6,0))) gross_amount,
355: sum(to_number(nvl(pai.action_information7,0))) amount_m_good
356: from per_all_assignments_f paf,
357: pay_assignment_actions paa,
358: pay_action_information pai,
359: pay_action_information pai_person
360: where paf.person_id = p_person_id
361: and paf.effective_end_date = (select max(paf2.effective_end_date)
425: use_index(pai_person,pay_action_information_n2)
426: use_index(pai,pay_action_information_n2) */
427: sum(to_number(nvl(pai.action_information10,0))) cash_equivalent
428: from per_all_assignments_f paf,
429: pay_assignment_actions paa,
430: pay_action_information pai,
431: pay_action_information pai_person
432: where paf.person_id = p_person_id
433: and paf.effective_end_date = (select max(paf2.effective_end_date)
487: use_index(pai_person,pay_action_information_n2)
488: use_index(pai,pay_action_information_n2) */
489: to_number(nvl(pai.action_information12,0)) cash_equivalent --Modified for the bug 11727875
490: from per_all_assignments_f paf,
491: pay_assignment_actions paa,
492: pay_action_information pai,
493: pay_action_information pai_person
494: where paf.person_id = p_person_id
495: and paf.effective_end_date = (select max(paf2.effective_end_date)
636: pai.action_information25 valid_benefit_end_date_flag, -- EOY 2008
637: pai.action_information26 date_free_fuel_withdrawn,
638: pai.action_information27 free_fuel_reinstated
639: from per_all_assignments_f paf,
640: pay_assignment_actions paa,
641: pay_action_information pai,
642: pay_action_information pai_person
643: where paf.person_id = p_person_id
644: and paf.effective_end_date = (select max(paf2.effective_end_date)
957: use_index(pai_person,pay_action_information_n2)
958: use_index(pai,pay_action_information_n2) */
959: sum(to_number(nvl(pai.action_information14,0))) cash_equivalent -- EOY 2008
960: from per_all_assignments_f paf,
961: pay_assignment_actions paa,
962: pay_action_information pai,
963: pay_action_information pai_person
964: where paf.person_id = p_person_id
965: and paf.effective_end_date = (select max(paf2.effective_end_date)
981: select /*+ ORDERED use_nl(paf,paa,pai)
982: use_index(pai,pay_action_information_n2) */
983: sum (pai.action_information30) vans_fuel
984: from per_all_assignments_f paf,
985: pay_assignment_actions paa,
986: pay_action_information pai
987: where paf.person_id = p_person_id
988: and paf.effective_end_date = (select max(paf2.effective_end_date)
989: from per_all_assignments_f paf2
1090: use_index(pai_person,pay_action_information_n2)
1091: use_index(pai,pay_action_information_n2) */
1092: sum(to_number(nvl(pai.action_information7,0)))
1093: from per_all_assignments_f paf,
1094: pay_assignment_actions paa,
1095: pay_action_information pai,
1096: pay_action_information pai_person
1097: where paf.person_id = p_person_id
1098: and paf.effective_end_date = (select max(paf2.effective_end_date)
1124: pai.action_information10 date_loan_discharged,
1125: to_number(nvl(pai.action_information11,1))cash_equivalent,
1126: to_number(nvl(pai.action_information16,1))amount_outstanding_at_year_end
1127: from per_all_assignments_f paf,
1128: pay_assignment_actions paa,
1129: pay_action_information pai,
1130: pay_action_information pai_person
1131: where paf.person_id = p_person_id
1132: and paf.effective_end_date = (select max(paf2.effective_end_date)
1272: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1273: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1274: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1275: from per_all_assignments_f paf,
1276: pay_assignment_actions paa,
1277: pay_action_information pai,
1278: pay_action_information pai_person
1279: where paf.person_id = p_person_id
1280: and paf.effective_end_date = (select max(paf2.effective_end_date)
1348: use_index(pai_person,pay_action_information_n2)
1349: use_index(pai,pay_action_information_n2) */
1350: sum(to_number(nvl(pai.action_information5,0))) cash_equivalent
1351: from per_all_assignments_f paf,
1352: pay_assignment_actions paa,
1353: pay_action_information pai,
1354: pay_action_information pai_person
1355: where paf.person_id = p_person_id
1356: and paf.effective_end_date = (select max(paf2.effective_end_date)
1420: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1421: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1422: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1423: from per_all_assignments_f paf,
1424: pay_assignment_actions paa,
1425: pay_action_information pai,
1426: pay_action_information pai_person
1427: where paf.person_id = p_person_id
1428: and paf.effective_end_date = (select max(paf2.effective_end_date)
1531: sum(to_number(nvl(pai.action_information9,0))) cash_equivalent,
1532: pay_gb_p11d_magtape.get_description(pai.action_information5,'GB_ASSETS',
1533: pai.action_information4) asset_type
1534: from per_all_assignments_f paf,
1535: pay_assignment_actions paa,
1536: pay_action_information pai,
1537: pay_action_information pai_person
1538: where paf.person_id = p_person_id
1539: and paf.effective_end_date = (select max(paf2.effective_end_date)
1700: sum(to_number(nvl(pai.action_information8,0))) amount_made_good,
1701: pay_gb_p11d_magtape.get_description(pai.action_information5,
1702: p_lookup, pai.action_information4) description
1703: from per_all_assignments_f paf,
1704: pay_assignment_actions paa,
1705: pay_action_information pai,
1706: pay_action_information pai_person
1707: where paf.person_id = p_person_id
1708: and paf.effective_end_date = (select max(paf2.effective_end_date)
1937: nvl(pai.action_information10,'N') trading_indicator,
1938: -- converted to upper for bug# 12715628
1939: upper(pai.action_information9) description --Added for the bug# 8708099
1940: from per_all_assignments_f paf,
1941: pay_assignment_actions paa,
1942: pay_action_information pai,
1943: pay_action_information pai_person
1944: where paf.person_id = p_person_id
1945: and paf.effective_end_date = (select max(paf2.effective_end_date)
2150: use_index(pai_person,pay_action_information_n2)
2151: use_index(pai,pay_action_information_n2) */
2152: sum(to_number(NVL(pai.action_information7, 0))) mileage_allowance
2153: from per_all_assignments_f paf,
2154: pay_assignment_actions paa,
2155: pay_action_information pai,
2156: pay_action_information pai_person
2157: where paf.person_id = p_person_id
2158: and paf.effective_end_date = (select max(paf2.effective_end_date)
2474: l_gender varchar2(1); -- EOY 2008
2475:
2476: cursor get_assact_id(p_pact_id number) is
2477: select action_context_id
2478: from pay_assignment_actions paa,
2479: pay_action_information pai
2480: where paa.payroll_action_id = p_pact_id
2481: and pai.action_context_id = paa.assignment_action_id
2482: and pai.action_information_category = 'ADDRESS DETAILS'
3126: use_index(pai_person,pay_action_information_n2)
3127: use_index(pai,pay_action_information_n2) */
3128: count(*)
3129: from per_all_assignments_f paf,
3130: pay_assignment_actions paa,
3131: pay_action_information pai,
3132: pay_action_information pai_person
3133: where paf.person_id = p_person_id
3134: and paf.effective_end_date = (select max(paf2.effective_end_date)
3187: select /*+ ORDERED use_nl(paa,pai,pai_person)
3188: use_index(pai_person,pay_action_information_n2)
3189: use_index(pai,pay_action_information_n2) */
3190: sum(pai.action_information7)
3191: from pay_assignment_actions paa,
3192: pay_action_information pai,
3193: pay_action_information pai_person
3194: where paa.assignment_action_id = p_assact_id
3195: and pai.action_context_id = paa.assignment_action_id
3223: 'ASSETS AT EMP DISPOSAL', pai.action_information9,
3224: 'OTHER ITEMS', pai.action_information9,
3225: 'OTHER ITEMS NON 1A', pai.action_information9,
3226: 'EXPENSES PAYMENTS', pai.action_information8)) total
3227: from pay_assignment_actions paa,
3228: pay_action_information pai,
3229: pay_action_information pai_a,
3230: pay_action_information pai_person
3231: where paa.assignment_action_id = p_assact_id
3267: 'ASSETS AT EMP DISPOSAL', pai.action_information9,
3268: 'OTHER ITEMS', pai.action_information9,
3269: 'OTHER ITEMS NON 1A', pai.action_information9,
3270: 'EXPENSES PAYMENTS', pai.action_information8)total
3271: from pay_assignment_actions paa,
3272: pay_action_information pai,
3273: pay_action_information pai_a,
3274: pay_action_information pai_c,
3275: pay_action_information pai_person