APPS.PAY_GB_P11D_EDI_2006 dependencies on PER_ALL_ASSIGNMENTS_F

Line 71: from per_all_assignments_f paf,

67: sum(to_number(nvl(pai.action_information8,0))) amount_made_good,
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

Line 77: from per_all_assignments_f paf2

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)
77: from per_all_assignments_f paf2
78: where paf2.assignment_id = paf.assignment_id
79: and paf2.person_id = p_person_id)
80: and paf.assignment_id = paa.assignment_id
81: and paa.payroll_action_id = p_pact_id

Line 233: from per_all_assignments_f paf,

229: sum(to_number(nvl(pai.action_information8,0))) tax_on_notional_payments,
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

Line 239: from per_all_assignments_f paf2

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)
239: from per_all_assignments_f paf2
240: where paf2.assignment_id = paf.assignment_id
241: and paf2.person_id = p_person_id)
242: and paf.assignment_id = paa.assignment_id
243: and paa.payroll_action_id = p_pact_id

Line 356: from per_all_assignments_f paf,

352: use_index(pai,pay_action_information_n2) */
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

Line 362: from per_all_assignments_f paf2

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)
362: from per_all_assignments_f paf2
363: where paf2.assignment_id = paf.assignment_id
364: and paf2.person_id = p_person_id)
365: and paf.assignment_id = paa.assignment_id
366: and paa.payroll_action_id = p_pact_id

Line 428: from per_all_assignments_f paf,

424: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
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

Line 434: from per_all_assignments_f paf2

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)
434: from per_all_assignments_f paf2
435: where paf2.assignment_id = paf.assignment_id
436: and paf2.person_id = p_person_id)
437: and paf.assignment_id = paa.assignment_id
438: and paa.payroll_action_id = p_pact_id

Line 490: from per_all_assignments_f paf,

486: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
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

Line 496: from per_all_assignments_f paf2

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)
496: from per_all_assignments_f paf2
497: where paf2.assignment_id = paf.assignment_id
498: and paf2.person_id = p_person_id)
499: and paf.assignment_id = paa.assignment_id
500: and paa.payroll_action_id = p_pact_id

Line 635: from per_all_assignments_f paf,

631: pai.action_information17 private_use_payments,
632: pai.action_information18 engine_cc,
633: pai.action_information26 date_free_fuel_withdrawn,
634: pai.action_information27 free_fuel_reinstated
635: from per_all_assignments_f paf,
636: pay_assignment_actions paa,
637: pay_action_information pai,
638: pay_action_information pai_person
639: where paf.person_id = p_person_id

Line 641: from per_all_assignments_f paf2

637: pay_action_information pai,
638: pay_action_information pai_person
639: where paf.person_id = p_person_id
640: and paf.effective_end_date = (select max(paf2.effective_end_date)
641: from per_all_assignments_f paf2
642: where paf2.assignment_id = paf.assignment_id
643: and paf2.person_id = p_person_id)
644: and paf.assignment_id = paa.assignment_id
645: and paa.payroll_action_id = p_pact_id

Line 911: from per_all_assignments_f paf,

907: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
908: use_index(pai_person,pay_action_information_n2)
909: use_index(pai,pay_action_information_n2) */
910: sum(to_number(nvl(pai.action_information15,0))) cash_equivalent
911: from per_all_assignments_f paf,
912: pay_assignment_actions paa,
913: pay_action_information pai,
914: pay_action_information pai_person
915: where paf.person_id = p_person_id

Line 917: from per_all_assignments_f paf2

913: pay_action_information pai,
914: pay_action_information pai_person
915: where paf.person_id = p_person_id
916: and paf.effective_end_date = (select max(paf2.effective_end_date)
917: from per_all_assignments_f paf2
918: where paf2.assignment_id = paf.assignment_id
919: and paf2.person_id = p_person_id)
920: and paf.assignment_id = paa.assignment_id
921: and paa.payroll_action_id = p_pact_id

Line 1005: from per_all_assignments_f paf,

1001: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
1002: use_index(pai_person,pay_action_information_n2)
1003: use_index(pai,pay_action_information_n2) */
1004: sum(to_number(nvl(pai.action_information7,0)))
1005: from per_all_assignments_f paf,
1006: pay_assignment_actions paa,
1007: pay_action_information pai,
1008: pay_action_information pai_person
1009: where paf.person_id = p_person_id

Line 1011: from per_all_assignments_f paf2

1007: pay_action_information pai,
1008: pay_action_information pai_person
1009: where paf.person_id = p_person_id
1010: and paf.effective_end_date = (select max(paf2.effective_end_date)
1011: from per_all_assignments_f paf2
1012: where paf2.assignment_id = paf.assignment_id
1013: and paf2.person_id = p_person_id)
1014: and paf.assignment_id = paa.assignment_id
1015: and paa.payroll_action_id = p_pact_id

Line 1039: from per_all_assignments_f paf,

1035: pai.action_information9 date_loan_made,
1036: pai.action_information10 date_loan_discharged,
1037: to_number(nvl(pai.action_information11,1))cash_equivalent,
1038: to_number(nvl(pai.action_information16,1))amount_outstanding_at_year_end
1039: from per_all_assignments_f paf,
1040: pay_assignment_actions paa,
1041: pay_action_information pai,
1042: pay_action_information pai_person
1043: where paf.person_id = p_person_id

Line 1045: from per_all_assignments_f paf2

1041: pay_action_information pai,
1042: pay_action_information pai_person
1043: where paf.person_id = p_person_id
1044: and paf.effective_end_date = (select max(paf2.effective_end_date)
1045: from per_all_assignments_f paf2
1046: where paf2.assignment_id = paf.assignment_id
1047: and paf2.person_id = p_person_id)
1048: and paf.assignment_id = paa.assignment_id
1049: and paa.payroll_action_id = p_pact_id

Line 1185: from per_all_assignments_f paf,

1181: use_index(pai,pay_action_information_n2) */
1182: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1183: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1184: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1185: from per_all_assignments_f paf,
1186: pay_assignment_actions paa,
1187: pay_action_information pai,
1188: pay_action_information pai_person
1189: where paf.person_id = p_person_id

Line 1191: from per_all_assignments_f paf2

1187: pay_action_information pai,
1188: pay_action_information pai_person
1189: where paf.person_id = p_person_id
1190: and paf.effective_end_date = (select max(paf2.effective_end_date)
1191: from per_all_assignments_f paf2
1192: where paf2.assignment_id = paf.assignment_id
1193: and paf2.person_id = p_person_id)
1194: and paf.assignment_id = paa.assignment_id
1195: and paa.payroll_action_id = p_pact_id

Line 1261: from per_all_assignments_f paf,

1257: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
1258: use_index(pai_person,pay_action_information_n2)
1259: use_index(pai,pay_action_information_n2) */
1260: sum(to_number(nvl(pai.action_information5,0))) cash_equivalent
1261: from per_all_assignments_f paf,
1262: pay_assignment_actions paa,
1263: pay_action_information pai,
1264: pay_action_information pai_person
1265: where paf.person_id = p_person_id

Line 1267: from per_all_assignments_f paf2

1263: pay_action_information pai,
1264: pay_action_information pai_person
1265: where paf.person_id = p_person_id
1266: and paf.effective_end_date = (select max(paf2.effective_end_date)
1267: from per_all_assignments_f paf2
1268: where paf2.assignment_id = paf.assignment_id
1269: and paf2.person_id = p_person_id)
1270: and paf.assignment_id = paa.assignment_id
1271: and paa.payroll_action_id = p_pact_id

Line 1333: from per_all_assignments_f paf,

1329: use_index(pai,pay_action_information_n2) */
1330: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1331: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1332: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1333: from per_all_assignments_f paf,
1334: pay_assignment_actions paa,
1335: pay_action_information pai,
1336: pay_action_information pai_person
1337: where paf.person_id = p_person_id

Line 1339: from per_all_assignments_f paf2

1335: pay_action_information pai,
1336: pay_action_information pai_person
1337: where paf.person_id = p_person_id
1338: and paf.effective_end_date = (select max(paf2.effective_end_date)
1339: from per_all_assignments_f paf2
1340: where paf2.assignment_id = paf.assignment_id
1341: and paf2.person_id = p_person_id)
1342: and paf.assignment_id = paa.assignment_id
1343: and paa.payroll_action_id = p_pact_id

Line 1444: from per_all_assignments_f paf,

1440: sum(to_number(nvl(pai.action_information8,0))) amount_made_good,
1441: sum(to_number(nvl(pai.action_information9,0))) cash_equivalent,
1442: pay_gb_p11d_magtape.get_description(pai.action_information5,'GB_ASSETS',
1443: pai.action_information4) asset_type
1444: from per_all_assignments_f paf,
1445: pay_assignment_actions paa,
1446: pay_action_information pai,
1447: pay_action_information pai_person
1448: where paf.person_id = p_person_id

Line 1450: from per_all_assignments_f paf2

1446: pay_action_information pai,
1447: pay_action_information pai_person
1448: where paf.person_id = p_person_id
1449: and paf.effective_end_date = (select max(paf2.effective_end_date)
1450: from per_all_assignments_f paf2
1451: where paf2.assignment_id = paf.assignment_id
1452: and paf2.person_id = p_person_id)
1453: and paf.assignment_id = paa.assignment_id
1454: and paa.payroll_action_id = p_pact_id

Line 1613: from per_all_assignments_f paf,

1609: sum(to_number(nvl(pai.action_information7,0))) cost_to_you,
1610: sum(to_number(nvl(pai.action_information8,0))) amount_made_good,
1611: pay_gb_p11d_magtape.get_description(pai.action_information5,
1612: p_lookup, pai.action_information4) description
1613: from per_all_assignments_f paf,
1614: pay_assignment_actions paa,
1615: pay_action_information pai,
1616: pay_action_information pai_person
1617: where paf.person_id = p_person_id

Line 1619: from per_all_assignments_f paf2

1615: pay_action_information pai,
1616: pay_action_information pai_person
1617: where paf.person_id = p_person_id
1618: and paf.effective_end_date = (select max(paf2.effective_end_date)
1619: from per_all_assignments_f paf2
1620: where paf2.assignment_id = paf.assignment_id
1621: and paf2.person_id = p_person_id)
1622: and paf.assignment_id = paa.assignment_id
1623: and paa.payroll_action_id = p_pact_id

Line 1847: from per_all_assignments_f paf,

1843: to_number(pai.action_information8) cash_equivalent,
1844: pay_gb_p11d_magtape.get_description(pai.action_information5,'GB_EXPENSE_TYPE',
1845: pai.action_information4) expense_type,
1846: nvl(pai.action_information10,'N') trading_indicator
1847: from per_all_assignments_f paf,
1848: pay_assignment_actions paa,
1849: pay_action_information pai,
1850: pay_action_information pai_person
1851: where paf.person_id = p_person_id

Line 1853: from per_all_assignments_f paf2

1849: pay_action_information pai,
1850: pay_action_information pai_person
1851: where paf.person_id = p_person_id
1852: and paf.effective_end_date = (select max(paf2.effective_end_date)
1853: from per_all_assignments_f paf2
1854: where paf2.assignment_id = paf.assignment_id
1855: and paf2.person_id = p_person_id)
1856: and paf.assignment_id = paa.assignment_id
1857: and paa.payroll_action_id = p_pact_id

Line 2039: from per_all_assignments_f paf,

2035: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
2036: use_index(pai_person,pay_action_information_n2)
2037: use_index(pai,pay_action_information_n2) */
2038: sum(to_number(NVL(pai.action_information7, 0))) mileage_allowance
2039: from per_all_assignments_f paf,
2040: pay_assignment_actions paa,
2041: pay_action_information pai,
2042: pay_action_information pai_person
2043: where paf.person_id = p_person_id

Line 2045: from per_all_assignments_f paf2

2041: pay_action_information pai,
2042: pay_action_information pai_person
2043: where paf.person_id = p_person_id
2044: and paf.effective_end_date = (select max(paf2.effective_end_date)
2045: from per_all_assignments_f paf2
2046: where paf2.assignment_id = paf.assignment_id
2047: and paf2.person_id = p_person_id)
2048: and paf.assignment_id = paa.assignment_id
2049: and paa.payroll_action_id = p_pact_id

Line 2962: from per_all_assignments_f paf,

2958: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
2959: use_index(pai_person,pay_action_information_n2)
2960: use_index(pai,pay_action_information_n2) */
2961: count(*)
2962: from per_all_assignments_f paf,
2963: pay_assignment_actions paa,
2964: pay_action_information pai,
2965: pay_action_information pai_person
2966: where paf.person_id = p_person_id

Line 2968: from per_all_assignments_f paf2

2964: pay_action_information pai,
2965: pay_action_information pai_person
2966: where paf.person_id = p_person_id
2967: and paf.effective_end_date = (select max(paf2.effective_end_date)
2968: from per_all_assignments_f paf2
2969: where paf2.assignment_id = paf.assignment_id
2970: and paf2.person_id = p_person_id)
2971: and paf.assignment_id = paa.assignment_id
2972: and paa.payroll_action_id = p_pact_id