[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)
631: pai.action_information18 engine_cc,
632: pai.action_information26 date_free_fuel_withdrawn,
633: pai.action_information27 free_fuel_reinstated
634: from per_all_assignments_f paf,
635: pay_assignment_actions paa,
636: pay_action_information pai,
637: pay_action_information pai_person
638: where paf.person_id = p_person_id
639: and paf.effective_end_date = (select max(paf2.effective_end_date)
896: use_index(pai_person,pay_action_information_n2)
897: use_index(pai,pay_action_information_n2) */
898: sum(to_number(nvl(pai.action_information15,0))) cash_equivalent
899: from per_all_assignments_f paf,
900: pay_assignment_actions paa,
901: pay_action_information pai,
902: pay_action_information pai_person
903: where paf.person_id = p_person_id
904: and paf.effective_end_date = (select max(paf2.effective_end_date)
990: use_index(pai_person,pay_action_information_n2)
991: use_index(pai,pay_action_information_n2) */
992: sum(to_number(nvl(pai.action_information7,0)))
993: from per_all_assignments_f paf,
994: pay_assignment_actions paa,
995: pay_action_information pai,
996: pay_action_information pai_person
997: where paf.person_id = p_person_id
998: and paf.effective_end_date = (select max(paf2.effective_end_date)
1024: pai.action_information10 date_loan_discharged,
1025: to_number(nvl(pai.action_information11,1))cash_equivalent,
1026: to_number(nvl(pai.action_information16,1))amount_outstanding_at_year_end
1027: from per_all_assignments_f paf,
1028: pay_assignment_actions paa,
1029: pay_action_information pai,
1030: pay_action_information pai_person
1031: where paf.person_id = p_person_id
1032: and paf.effective_end_date = (select max(paf2.effective_end_date)
1170: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1171: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1172: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1173: from per_all_assignments_f paf,
1174: pay_assignment_actions paa,
1175: pay_action_information pai,
1176: pay_action_information pai_person
1177: where paf.person_id = p_person_id
1178: and paf.effective_end_date = (select max(paf2.effective_end_date)
1246: use_index(pai_person,pay_action_information_n2)
1247: use_index(pai,pay_action_information_n2) */
1248: sum(to_number(nvl(pai.action_information5,0))) cash_equivalent
1249: from per_all_assignments_f paf,
1250: pay_assignment_actions paa,
1251: pay_action_information pai,
1252: pay_action_information pai_person
1253: where paf.person_id = p_person_id
1254: and paf.effective_end_date = (select max(paf2.effective_end_date)
1318: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1319: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1320: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1321: from per_all_assignments_f paf,
1322: pay_assignment_actions paa,
1323: pay_action_information pai,
1324: pay_action_information pai_person
1325: where paf.person_id = p_person_id
1326: and paf.effective_end_date = (select max(paf2.effective_end_date)
1429: sum(to_number(nvl(pai.action_information9,0))) cash_equivalent,
1430: pay_gb_p11d_magtape.get_description(pai.action_information5,'GB_ASSETS',
1431: pai.action_information4) asset_type
1432: from per_all_assignments_f paf,
1433: pay_assignment_actions paa,
1434: pay_action_information pai,
1435: pay_action_information pai_person
1436: where paf.person_id = p_person_id
1437: and paf.effective_end_date = (select max(paf2.effective_end_date)
1598: sum(to_number(nvl(pai.action_information8,0))) amount_made_good,
1599: pay_gb_p11d_magtape.get_description(pai.action_information5,
1600: p_lookup, pai.action_information4) description
1601: from per_all_assignments_f paf,
1602: pay_assignment_actions paa,
1603: pay_action_information pai,
1604: pay_action_information pai_person
1605: where paf.person_id = p_person_id
1606: and paf.effective_end_date = (select max(paf2.effective_end_date)
1832: pay_gb_p11d_magtape.get_description(pai.action_information5,'GB_EXPENSE_TYPE',
1833: pai.action_information4) expense_type,
1834: nvl(pai.action_information10,'N') trading_indicator
1835: from per_all_assignments_f paf,
1836: pay_assignment_actions paa,
1837: pay_action_information pai,
1838: pay_action_information pai_person
1839: where paf.person_id = p_person_id
1840: and paf.effective_end_date = (select max(paf2.effective_end_date)
2005: use_index(pai_person,pay_action_information_n2)
2006: use_index(pai,pay_action_information_n2) */
2007: sum(to_number(NVL(pai.action_information7, 0))) mileage_allowance
2008: from per_all_assignments_f paf,
2009: pay_assignment_actions paa,
2010: pay_action_information pai,
2011: pay_action_information pai_person
2012: where paf.person_id = p_person_id
2013: and paf.effective_end_date = (select max(paf2.effective_end_date)
2286: l_addr5 varchar2(255);
2287:
2288: cursor get_assact_id(p_pact_id number) is
2289: select action_context_id
2290: from pay_assignment_actions paa,
2291: pay_action_information pai
2292: where paa.payroll_action_id = p_pact_id
2293: and pai.action_context_id = paa.assignment_action_id
2294: and pai.action_information_category = 'ADDRESS DETAILS'
2908: use_index(pai_person,pay_action_information_n2)
2909: use_index(pai,pay_action_information_n2) */
2910: count(*)
2911: from per_all_assignments_f paf,
2912: pay_assignment_actions paa,
2913: pay_action_information pai,
2914: pay_action_information pai_person
2915: where paf.person_id = p_person_id
2916: and paf.effective_end_date = (select max(paf2.effective_end_date)