[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: sum(to_number(nvl(pai.action_information12,0))) cash_equivalent
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)
935: use_index(pai_person,pay_action_information_n2)
936: use_index(pai,pay_action_information_n2) */
937: sum(to_number(nvl(pai.action_information14,0))) cash_equivalent -- EOY 2008
938: from per_all_assignments_f paf,
939: pay_assignment_actions paa,
940: pay_action_information pai,
941: pay_action_information pai_person
942: where paf.person_id = p_person_id
943: and paf.effective_end_date = (select max(paf2.effective_end_date)
959: select /*+ ORDERED use_nl(paf,paa,pai)
960: use_index(pai,pay_action_information_n2) */
961: sum (pai.action_information30) vans_fuel
962: from per_all_assignments_f paf,
963: pay_assignment_actions paa,
964: pay_action_information pai
965: where paf.person_id = p_person_id
966: and paf.effective_end_date = (select max(paf2.effective_end_date)
967: from per_all_assignments_f paf2
1068: use_index(pai_person,pay_action_information_n2)
1069: use_index(pai,pay_action_information_n2) */
1070: sum(to_number(nvl(pai.action_information7,0)))
1071: from per_all_assignments_f paf,
1072: pay_assignment_actions paa,
1073: pay_action_information pai,
1074: pay_action_information pai_person
1075: where paf.person_id = p_person_id
1076: and paf.effective_end_date = (select max(paf2.effective_end_date)
1102: pai.action_information10 date_loan_discharged,
1103: to_number(nvl(pai.action_information11,1))cash_equivalent,
1104: to_number(nvl(pai.action_information16,1))amount_outstanding_at_year_end
1105: from per_all_assignments_f paf,
1106: pay_assignment_actions paa,
1107: pay_action_information pai,
1108: pay_action_information pai_person
1109: where paf.person_id = p_person_id
1110: and paf.effective_end_date = (select max(paf2.effective_end_date)
1250: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1251: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1252: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1253: from per_all_assignments_f paf,
1254: pay_assignment_actions paa,
1255: pay_action_information pai,
1256: pay_action_information pai_person
1257: where paf.person_id = p_person_id
1258: and paf.effective_end_date = (select max(paf2.effective_end_date)
1326: use_index(pai_person,pay_action_information_n2)
1327: use_index(pai,pay_action_information_n2) */
1328: sum(to_number(nvl(pai.action_information5,0))) cash_equivalent
1329: from per_all_assignments_f paf,
1330: pay_assignment_actions paa,
1331: pay_action_information pai,
1332: pay_action_information pai_person
1333: where paf.person_id = p_person_id
1334: and paf.effective_end_date = (select max(paf2.effective_end_date)
1398: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1399: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1400: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1401: from per_all_assignments_f paf,
1402: pay_assignment_actions paa,
1403: pay_action_information pai,
1404: pay_action_information pai_person
1405: where paf.person_id = p_person_id
1406: and paf.effective_end_date = (select max(paf2.effective_end_date)
1509: sum(to_number(nvl(pai.action_information9,0))) cash_equivalent,
1510: pay_gb_p11d_magtape.get_description(pai.action_information5,'GB_ASSETS',
1511: pai.action_information4) asset_type
1512: from per_all_assignments_f paf,
1513: pay_assignment_actions paa,
1514: pay_action_information pai,
1515: pay_action_information pai_person
1516: where paf.person_id = p_person_id
1517: and paf.effective_end_date = (select max(paf2.effective_end_date)
1678: sum(to_number(nvl(pai.action_information8,0))) amount_made_good,
1679: pay_gb_p11d_magtape.get_description(pai.action_information5,
1680: p_lookup, pai.action_information4) description
1681: from per_all_assignments_f paf,
1682: pay_assignment_actions paa,
1683: pay_action_information pai,
1684: pay_action_information pai_person
1685: where paf.person_id = p_person_id
1686: and paf.effective_end_date = (select max(paf2.effective_end_date)
1912: pay_gb_p11d_magtape.get_description(pai.action_information5,'GB_EXPENSE_TYPE',
1913: pai.action_information4) expense_type,
1914: nvl(pai.action_information10,'N') trading_indicator
1915: from per_all_assignments_f paf,
1916: pay_assignment_actions paa,
1917: pay_action_information pai,
1918: pay_action_information pai_person
1919: where paf.person_id = p_person_id
1920: and paf.effective_end_date = (select max(paf2.effective_end_date)
2104: use_index(pai_person,pay_action_information_n2)
2105: use_index(pai,pay_action_information_n2) */
2106: sum(to_number(NVL(pai.action_information7, 0))) mileage_allowance
2107: from per_all_assignments_f paf,
2108: pay_assignment_actions paa,
2109: pay_action_information pai,
2110: pay_action_information pai_person
2111: where paf.person_id = p_person_id
2112: and paf.effective_end_date = (select max(paf2.effective_end_date)
2423: l_gender varchar2(1); -- EOY 2008
2424:
2425: cursor get_assact_id(p_pact_id number) is
2426: select action_context_id
2427: from pay_assignment_actions paa,
2428: pay_action_information pai
2429: where paa.payroll_action_id = p_pact_id
2430: and pai.action_context_id = paa.assignment_action_id
2431: and pai.action_information_category = 'ADDRESS DETAILS'
3074: use_index(pai_person,pay_action_information_n2)
3075: use_index(pai,pay_action_information_n2) */
3076: count(*)
3077: from per_all_assignments_f paf,
3078: pay_assignment_actions paa,
3079: pay_action_information pai,
3080: pay_action_information pai_person
3081: where paf.person_id = p_person_id
3082: and paf.effective_end_date = (select max(paf2.effective_end_date)
3135: select /*+ ORDERED use_nl(paa,pai,pai_person)
3136: use_index(pai_person,pay_action_information_n2)
3137: use_index(pai,pay_action_information_n2) */
3138: sum(pai.action_information7)
3139: from pay_assignment_actions paa,
3140: pay_action_information pai,
3141: pay_action_information pai_person
3142: where paa.assignment_action_id = p_assact_id
3143: and pai.action_context_id = paa.assignment_action_id
3171: 'ASSETS AT EMP DISPOSAL', pai.action_information9,
3172: 'OTHER ITEMS', pai.action_information9,
3173: 'OTHER ITEMS NON 1A', pai.action_information9,
3174: 'EXPENSES PAYMENTS', pai.action_information8)) total
3175: from pay_assignment_actions paa,
3176: pay_action_information pai,
3177: pay_action_information pai_a,
3178: pay_action_information pai_person
3179: where paa.assignment_action_id = p_assact_id
3209: 'ASSETS AT EMP DISPOSAL', pai.action_information9,
3210: 'OTHER ITEMS', pai.action_information9,
3211: 'OTHER ITEMS NON 1A', pai.action_information9,
3212: 'EXPENSES PAYMENTS', pai.action_information8)total
3213: from pay_assignment_actions paa,
3214: pay_action_information pai,
3215: pay_action_information pai_a,
3216: pay_action_information pai_person
3217: where paa.assignment_action_id = p_assact_id