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_2008 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 639: from per_all_assignments_f paf,

635: pai.action_information18 engine_cc,
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

Line 645: from per_all_assignments_f paf2

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)
645: from per_all_assignments_f paf2
646: where paf2.assignment_id = paf.assignment_id
647: and paf2.person_id = p_person_id)
648: and paf.assignment_id = paa.assignment_id
649: and paa.payroll_action_id = p_pact_id

Line 938: from per_all_assignments_f paf,

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

Line 944: from per_all_assignments_f paf2

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)
944: from per_all_assignments_f paf2
945: where paf2.assignment_id = paf.assignment_id
946: and paf2.person_id = p_person_id)
947: and paf.assignment_id = paa.assignment_id
948: and paa.payroll_action_id = p_pact_id

Line 962: from per_all_assignments_f paf,

958: cursor get_data2 is
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)

Line 967: from per_all_assignments_f paf2

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
968: where paf2.assignment_id = paf.assignment_id
969: and paf2.person_id = p_person_id)
970: and paf.assignment_id = paa.assignment_id
971: and paa.payroll_action_id = p_pact_id

Line 1071: from per_all_assignments_f paf,

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

Line 1077: from per_all_assignments_f paf2

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)
1077: from per_all_assignments_f paf2
1078: where paf2.assignment_id = paf.assignment_id
1079: and paf2.person_id = p_person_id)
1080: and paf.assignment_id = paa.assignment_id
1081: and paa.payroll_action_id = p_pact_id

Line 1105: from per_all_assignments_f paf,

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

Line 1111: from per_all_assignments_f paf2

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)
1111: from per_all_assignments_f paf2
1112: where paf2.assignment_id = paf.assignment_id
1113: and paf2.person_id = p_person_id)
1114: and paf.assignment_id = paa.assignment_id
1115: and paa.payroll_action_id = p_pact_id

Line 1253: from per_all_assignments_f paf,

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

Line 1259: from per_all_assignments_f paf2

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)
1259: from per_all_assignments_f paf2
1260: where paf2.assignment_id = paf.assignment_id
1261: and paf2.person_id = p_person_id)
1262: and paf.assignment_id = paa.assignment_id
1263: and paa.payroll_action_id = p_pact_id

Line 1329: from per_all_assignments_f paf,

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

Line 1335: from per_all_assignments_f paf2

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)
1335: from per_all_assignments_f paf2
1336: where paf2.assignment_id = paf.assignment_id
1337: and paf2.person_id = p_person_id)
1338: and paf.assignment_id = paa.assignment_id
1339: and paa.payroll_action_id = p_pact_id

Line 1401: from per_all_assignments_f paf,

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

Line 1407: from per_all_assignments_f paf2

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)
1407: from per_all_assignments_f paf2
1408: where paf2.assignment_id = paf.assignment_id
1409: and paf2.person_id = p_person_id)
1410: and paf.assignment_id = paa.assignment_id
1411: and paa.payroll_action_id = p_pact_id

Line 1512: from per_all_assignments_f paf,

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

Line 1518: from per_all_assignments_f paf2

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)
1518: from per_all_assignments_f paf2
1519: where paf2.assignment_id = paf.assignment_id
1520: and paf2.person_id = p_person_id)
1521: and paf.assignment_id = paa.assignment_id
1522: and paa.payroll_action_id = p_pact_id

Line 1681: from per_all_assignments_f paf,

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

Line 1687: from per_all_assignments_f paf2

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)
1687: from per_all_assignments_f paf2
1688: where paf2.assignment_id = paf.assignment_id
1689: and paf2.person_id = p_person_id)
1690: and paf.assignment_id = paa.assignment_id
1691: and paa.payroll_action_id = p_pact_id

Line 1915: from per_all_assignments_f paf,

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

Line 1921: from per_all_assignments_f paf2

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)
1921: from per_all_assignments_f paf2
1922: where paf2.assignment_id = paf.assignment_id
1923: and paf2.person_id = p_person_id)
1924: and paf.assignment_id = paa.assignment_id
1925: and paa.payroll_action_id = p_pact_id

Line 2107: from per_all_assignments_f paf,

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

Line 2113: from per_all_assignments_f paf2

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)
2113: from per_all_assignments_f paf2
2114: where paf2.assignment_id = paf.assignment_id
2115: and paf2.person_id = p_person_id)
2116: and paf.assignment_id = paa.assignment_id
2117: and paa.payroll_action_id = p_pact_id

Line 3077: from per_all_assignments_f paf,

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

Line 3083: from per_all_assignments_f paf2

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)
3083: from per_all_assignments_f paf2
3084: where paf2.assignment_id = paf.assignment_id
3085: and paf2.person_id = p_person_id)
3086: and paf.assignment_id = paa.assignment_id
3087: and paa.payroll_action_id = p_pact_id