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_2006 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 72: pay_assignment_actions paa,

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)

Line 234: pay_assignment_actions paa,

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)

Line 357: pay_assignment_actions paa,

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)

Line 429: pay_assignment_actions paa,

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)

Line 491: pay_assignment_actions paa,

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)

Line 636: pay_assignment_actions paa,

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
640: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 912: pay_assignment_actions paa,

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
916: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 1006: pay_assignment_actions paa,

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
1010: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 1040: pay_assignment_actions paa,

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
1044: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 1186: pay_assignment_actions paa,

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
1190: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 1262: pay_assignment_actions paa,

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
1266: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 1334: pay_assignment_actions paa,

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
1338: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 1445: pay_assignment_actions paa,

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
1449: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 1614: pay_assignment_actions paa,

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
1618: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 1848: pay_assignment_actions paa,

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
1852: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 2040: pay_assignment_actions paa,

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
2044: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 2342: from pay_assignment_actions paa,

2338: l_addr5 varchar2(255);
2339:
2340: cursor get_assact_id(p_pact_id number) is
2341: select action_context_id
2342: from pay_assignment_actions paa,
2343: pay_action_information pai
2344: where paa.payroll_action_id = p_pact_id
2345: and pai.action_context_id = paa.assignment_action_id
2346: and pai.action_information_category = 'ADDRESS DETAILS'

Line 2963: pay_assignment_actions paa,

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
2967: and paf.effective_end_date = (select max(paf2.effective_end_date)

Line 3024: from pay_assignment_actions paa,

3020: select /*+ ORDERED use_nl(paa,pai,pai_person)
3021: use_index(pai_person,pay_action_information_n2)
3022: use_index(pai,pay_action_information_n2) */
3023: sum(pai.action_information7)
3024: from pay_assignment_actions paa,
3025: pay_action_information pai,
3026: pay_action_information pai_person
3027: where paa.assignment_action_id = p_assact_id
3028: and pai.action_context_id = paa.assignment_action_id

Line 3058: from pay_assignment_actions paa,

3054: 'ASSETS AT EMP DISPOSAL', pai.action_information9,
3055: 'OTHER ITEMS', pai.action_information9,
3056: 'OTHER ITEMS NON 1A', pai.action_information9,
3057: 'EXPENSES PAYMENTS', pai.action_information8)) total
3058: from pay_assignment_actions paa,
3059: pay_action_information pai,
3060: pay_action_information pai_a,
3061: pay_action_information pai_person
3062: where paa.assignment_action_id = p_assact_id