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: to_number(nvl(pai.action_information12,0)) cash_equivalent --Modified for the bug 11727875
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 960: from per_all_assignments_f paf,

956: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
957: use_index(pai_person,pay_action_information_n2)
958: use_index(pai,pay_action_information_n2) */
959: sum(to_number(nvl(pai.action_information14,0))) cash_equivalent -- EOY 2008
960: from per_all_assignments_f paf,
961: pay_assignment_actions paa,
962: pay_action_information pai,
963: pay_action_information pai_person
964: where paf.person_id = p_person_id

Line 966: from per_all_assignments_f paf2

962: pay_action_information pai,
963: pay_action_information pai_person
964: where paf.person_id = p_person_id
965: and paf.effective_end_date = (select max(paf2.effective_end_date)
966: from per_all_assignments_f paf2
967: where paf2.assignment_id = paf.assignment_id
968: and paf2.person_id = p_person_id)
969: and paf.assignment_id = paa.assignment_id
970: and paa.payroll_action_id = p_pact_id

Line 984: from per_all_assignments_f paf,

980: cursor get_data2 is
981: select /*+ ORDERED use_nl(paf,paa,pai)
982: use_index(pai,pay_action_information_n2) */
983: sum (pai.action_information30) vans_fuel
984: from per_all_assignments_f paf,
985: pay_assignment_actions paa,
986: pay_action_information pai
987: where paf.person_id = p_person_id
988: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 989: from per_all_assignments_f paf2

985: pay_assignment_actions paa,
986: pay_action_information pai
987: where paf.person_id = p_person_id
988: and paf.effective_end_date = (select max(paf2.effective_end_date)
989: from per_all_assignments_f paf2
990: where paf2.assignment_id = paf.assignment_id
991: and paf2.person_id = p_person_id)
992: and paf.assignment_id = paa.assignment_id
993: and paa.payroll_action_id = p_pact_id

Line 1093: from per_all_assignments_f paf,

1089: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
1090: use_index(pai_person,pay_action_information_n2)
1091: use_index(pai,pay_action_information_n2) */
1092: sum(to_number(nvl(pai.action_information7,0)))
1093: from per_all_assignments_f paf,
1094: pay_assignment_actions paa,
1095: pay_action_information pai,
1096: pay_action_information pai_person
1097: where paf.person_id = p_person_id

Line 1099: from per_all_assignments_f paf2

1095: pay_action_information pai,
1096: pay_action_information pai_person
1097: where paf.person_id = p_person_id
1098: and paf.effective_end_date = (select max(paf2.effective_end_date)
1099: from per_all_assignments_f paf2
1100: where paf2.assignment_id = paf.assignment_id
1101: and paf2.person_id = p_person_id)
1102: and paf.assignment_id = paa.assignment_id
1103: and paa.payroll_action_id = p_pact_id

Line 1127: from per_all_assignments_f paf,

1123: pai.action_information9 date_loan_made,
1124: pai.action_information10 date_loan_discharged,
1125: to_number(nvl(pai.action_information11,1))cash_equivalent,
1126: to_number(nvl(pai.action_information16,1))amount_outstanding_at_year_end
1127: from per_all_assignments_f paf,
1128: pay_assignment_actions paa,
1129: pay_action_information pai,
1130: pay_action_information pai_person
1131: where paf.person_id = p_person_id

Line 1133: from per_all_assignments_f paf2

1129: pay_action_information pai,
1130: pay_action_information pai_person
1131: where paf.person_id = p_person_id
1132: and paf.effective_end_date = (select max(paf2.effective_end_date)
1133: from per_all_assignments_f paf2
1134: where paf2.assignment_id = paf.assignment_id
1135: and paf2.person_id = p_person_id)
1136: and paf.assignment_id = paa.assignment_id
1137: and paa.payroll_action_id = p_pact_id

Line 1275: from per_all_assignments_f paf,

1271: use_index(pai,pay_action_information_n2) */
1272: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1273: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1274: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1275: from per_all_assignments_f paf,
1276: pay_assignment_actions paa,
1277: pay_action_information pai,
1278: pay_action_information pai_person
1279: where paf.person_id = p_person_id

Line 1281: from per_all_assignments_f paf2

1277: pay_action_information pai,
1278: pay_action_information pai_person
1279: where paf.person_id = p_person_id
1280: and paf.effective_end_date = (select max(paf2.effective_end_date)
1281: from per_all_assignments_f paf2
1282: where paf2.assignment_id = paf.assignment_id
1283: and paf2.person_id = p_person_id)
1284: and paf.assignment_id = paa.assignment_id
1285: and paa.payroll_action_id = p_pact_id

Line 1351: from per_all_assignments_f paf,

1347: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
1348: use_index(pai_person,pay_action_information_n2)
1349: use_index(pai,pay_action_information_n2) */
1350: sum(to_number(nvl(pai.action_information5,0))) cash_equivalent
1351: from per_all_assignments_f paf,
1352: pay_assignment_actions paa,
1353: pay_action_information pai,
1354: pay_action_information pai_person
1355: where paf.person_id = p_person_id

Line 1357: from per_all_assignments_f paf2

1353: pay_action_information pai,
1354: pay_action_information pai_person
1355: where paf.person_id = p_person_id
1356: and paf.effective_end_date = (select max(paf2.effective_end_date)
1357: from per_all_assignments_f paf2
1358: where paf2.assignment_id = paf.assignment_id
1359: and paf2.person_id = p_person_id)
1360: and paf.assignment_id = paa.assignment_id
1361: and paa.payroll_action_id = p_pact_id

Line 1423: from per_all_assignments_f paf,

1419: use_index(pai,pay_action_information_n2) */
1420: sum(to_number(nvl(pai.action_information7,0))) cash_equivalent,
1421: sum(to_number(nvl(pai.action_information5,0))) cost_to_you,
1422: sum(to_number(nvl(pai.action_information6,0))) amount_m_good
1423: from per_all_assignments_f paf,
1424: pay_assignment_actions paa,
1425: pay_action_information pai,
1426: pay_action_information pai_person
1427: where paf.person_id = p_person_id

Line 1429: from per_all_assignments_f paf2

1425: pay_action_information pai,
1426: pay_action_information pai_person
1427: where paf.person_id = p_person_id
1428: and paf.effective_end_date = (select max(paf2.effective_end_date)
1429: from per_all_assignments_f paf2
1430: where paf2.assignment_id = paf.assignment_id
1431: and paf2.person_id = p_person_id)
1432: and paf.assignment_id = paa.assignment_id
1433: and paa.payroll_action_id = p_pact_id

Line 1534: from per_all_assignments_f paf,

1530: sum(to_number(nvl(pai.action_information8,0))) amount_made_good,
1531: sum(to_number(nvl(pai.action_information9,0))) cash_equivalent,
1532: pay_gb_p11d_magtape.get_description(pai.action_information5,'GB_ASSETS',
1533: pai.action_information4) asset_type
1534: from per_all_assignments_f paf,
1535: pay_assignment_actions paa,
1536: pay_action_information pai,
1537: pay_action_information pai_person
1538: where paf.person_id = p_person_id

Line 1540: from per_all_assignments_f paf2

1536: pay_action_information pai,
1537: pay_action_information pai_person
1538: where paf.person_id = p_person_id
1539: and paf.effective_end_date = (select max(paf2.effective_end_date)
1540: from per_all_assignments_f paf2
1541: where paf2.assignment_id = paf.assignment_id
1542: and paf2.person_id = p_person_id)
1543: and paf.assignment_id = paa.assignment_id
1544: and paa.payroll_action_id = p_pact_id

Line 1703: from per_all_assignments_f paf,

1699: sum(to_number(nvl(pai.action_information7,0))) cost_to_you,
1700: sum(to_number(nvl(pai.action_information8,0))) amount_made_good,
1701: pay_gb_p11d_magtape.get_description(pai.action_information5,
1702: p_lookup, pai.action_information4) description
1703: from per_all_assignments_f paf,
1704: pay_assignment_actions paa,
1705: pay_action_information pai,
1706: pay_action_information pai_person
1707: where paf.person_id = p_person_id

Line 1709: from per_all_assignments_f paf2

1705: pay_action_information pai,
1706: pay_action_information pai_person
1707: where paf.person_id = p_person_id
1708: and paf.effective_end_date = (select max(paf2.effective_end_date)
1709: from per_all_assignments_f paf2
1710: where paf2.assignment_id = paf.assignment_id
1711: and paf2.person_id = p_person_id)
1712: and paf.assignment_id = paa.assignment_id
1713: and paa.payroll_action_id = p_pact_id

Line 1940: from per_all_assignments_f paf,

1936: pai.action_information4) expense_type,
1937: nvl(pai.action_information10,'N') trading_indicator,
1938: -- converted to upper for bug# 12715628
1939: upper(pai.action_information9) description --Added for the bug# 8708099
1940: from per_all_assignments_f paf,
1941: pay_assignment_actions paa,
1942: pay_action_information pai,
1943: pay_action_information pai_person
1944: where paf.person_id = p_person_id

Line 1946: from per_all_assignments_f paf2

1942: pay_action_information pai,
1943: pay_action_information pai_person
1944: where paf.person_id = p_person_id
1945: and paf.effective_end_date = (select max(paf2.effective_end_date)
1946: from per_all_assignments_f paf2
1947: where paf2.assignment_id = paf.assignment_id
1948: and paf2.person_id = p_person_id)
1949: and paf.assignment_id = paa.assignment_id
1950: and paa.payroll_action_id = p_pact_id

Line 2153: from per_all_assignments_f paf,

2149: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
2150: use_index(pai_person,pay_action_information_n2)
2151: use_index(pai,pay_action_information_n2) */
2152: sum(to_number(NVL(pai.action_information7, 0))) mileage_allowance
2153: from per_all_assignments_f paf,
2154: pay_assignment_actions paa,
2155: pay_action_information pai,
2156: pay_action_information pai_person
2157: where paf.person_id = p_person_id

Line 2159: from per_all_assignments_f paf2

2155: pay_action_information pai,
2156: pay_action_information pai_person
2157: where paf.person_id = p_person_id
2158: and paf.effective_end_date = (select max(paf2.effective_end_date)
2159: from per_all_assignments_f paf2
2160: where paf2.assignment_id = paf.assignment_id
2161: and paf2.person_id = p_person_id)
2162: and paf.assignment_id = paa.assignment_id
2163: and paa.payroll_action_id = p_pact_id

Line 3129: from per_all_assignments_f paf,

3125: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
3126: use_index(pai_person,pay_action_information_n2)
3127: use_index(pai,pay_action_information_n2) */
3128: count(*)
3129: from per_all_assignments_f paf,
3130: pay_assignment_actions paa,
3131: pay_action_information pai,
3132: pay_action_information pai_person
3133: where paf.person_id = p_person_id

Line 3135: from per_all_assignments_f paf2

3131: pay_action_information pai,
3132: pay_action_information pai_person
3133: where paf.person_id = p_person_id
3134: and paf.effective_end_date = (select max(paf2.effective_end_date)
3135: from per_all_assignments_f paf2
3136: where paf2.assignment_id = paf.assignment_id
3137: and paf2.person_id = p_person_id)
3138: and paf.assignment_id = paa.assignment_id
3139: and paa.payroll_action_id = p_pact_id