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_GB_P11D_EDI_2005 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 634: from per_all_assignments_f paf,

630: pai.action_information17 private_use_payments,
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

Line 640: from per_all_assignments_f paf2

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)
640: from per_all_assignments_f paf2
641: where paf2.assignment_id = paf.assignment_id
642: and paf2.person_id = p_person_id)
643: and paf.assignment_id = paa.assignment_id
644: and paa.payroll_action_id = p_pact_id

Line 899: from per_all_assignments_f paf,

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

Line 905: from per_all_assignments_f paf2

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)
905: from per_all_assignments_f paf2
906: where paf2.assignment_id = paf.assignment_id
907: and paf2.person_id = p_person_id)
908: and paf.assignment_id = paa.assignment_id
909: and paa.payroll_action_id = p_pact_id

Line 993: from per_all_assignments_f paf,

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

Line 999: from per_all_assignments_f paf2

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)
999: from per_all_assignments_f paf2
1000: where paf2.assignment_id = paf.assignment_id
1001: and paf2.person_id = p_person_id)
1002: and paf.assignment_id = paa.assignment_id
1003: and paa.payroll_action_id = p_pact_id

Line 1027: from per_all_assignments_f paf,

1023: pai.action_information9 date_loan_made,
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

Line 1033: from per_all_assignments_f paf2

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)
1033: from per_all_assignments_f paf2
1034: where paf2.assignment_id = paf.assignment_id
1035: and paf2.person_id = p_person_id)
1036: and paf.assignment_id = paa.assignment_id
1037: and paa.payroll_action_id = p_pact_id

Line 1173: from per_all_assignments_f paf,

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

Line 1179: from per_all_assignments_f paf2

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)
1179: from per_all_assignments_f paf2
1180: where paf2.assignment_id = paf.assignment_id
1181: and paf2.person_id = p_person_id)
1182: and paf.assignment_id = paa.assignment_id
1183: and paa.payroll_action_id = p_pact_id

Line 1249: from per_all_assignments_f paf,

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

Line 1255: from per_all_assignments_f paf2

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)
1255: from per_all_assignments_f paf2
1256: where paf2.assignment_id = paf.assignment_id
1257: and paf2.person_id = p_person_id)
1258: and paf.assignment_id = paa.assignment_id
1259: and paa.payroll_action_id = p_pact_id

Line 1321: from per_all_assignments_f paf,

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

Line 1327: from per_all_assignments_f paf2

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)
1327: from per_all_assignments_f paf2
1328: where paf2.assignment_id = paf.assignment_id
1329: and paf2.person_id = p_person_id)
1330: and paf.assignment_id = paa.assignment_id
1331: and paa.payroll_action_id = p_pact_id

Line 1432: from per_all_assignments_f paf,

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

Line 1438: from per_all_assignments_f paf2

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)
1438: from per_all_assignments_f paf2
1439: where paf2.assignment_id = paf.assignment_id
1440: and paf2.person_id = p_person_id)
1441: and paf.assignment_id = paa.assignment_id
1442: and paa.payroll_action_id = p_pact_id

Line 1601: from per_all_assignments_f paf,

1597: sum(to_number(nvl(pai.action_information7,0))) cost_to_you,
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

Line 1607: from per_all_assignments_f paf2

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)
1607: from per_all_assignments_f paf2
1608: where paf2.assignment_id = paf.assignment_id
1609: and paf2.person_id = p_person_id)
1610: and paf.assignment_id = paa.assignment_id
1611: and paa.payroll_action_id = p_pact_id

Line 1835: from per_all_assignments_f paf,

1831: to_number(pai.action_information8) cash_equivalent,
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

Line 1841: from per_all_assignments_f paf2

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)
1841: from per_all_assignments_f paf2
1842: where paf2.assignment_id = paf.assignment_id
1843: and paf2.person_id = p_person_id)
1844: and paf.assignment_id = paa.assignment_id
1845: and paa.payroll_action_id = p_pact_id

Line 2008: from per_all_assignments_f paf,

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

Line 2014: from per_all_assignments_f paf2

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)
2014: from per_all_assignments_f paf2
2015: where paf2.assignment_id = paf.assignment_id
2016: and paf2.person_id = p_person_id)
2017: and paf.assignment_id = paa.assignment_id
2018: and paa.payroll_action_id = p_pact_id

Line 2911: from per_all_assignments_f paf,

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

Line 2917: from per_all_assignments_f paf2

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)
2917: from per_all_assignments_f paf2
2918: where paf2.assignment_id = paf.assignment_id
2919: and paf2.person_id = p_person_id)
2920: and paf.assignment_id = paa.assignment_id
2921: and paa.payroll_action_id = p_pact_id