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

Line 294: pay_assignment_actions paa,

290:
291: SELECT ptp.start_date
292: FROM per_time_periods ptp,
293: pay_payroll_actions ppa,
294: pay_assignment_actions paa,
295: pay_run_results prr,
296: pay_element_entries_f pee
297: WHERE pee.element_entry_id=c_element_entry_id
298: and prr.run_result_id = pee.source_id

Line 314: pay_assignment_actions paa,

310:
311: SELECT ptp.start_date
312: FROM per_time_periods ptp,
313: pay_payroll_actions ppa,
314: pay_assignment_actions paa,
315: pay_run_results prr,
316: pay_element_entries_f pee
317: WHERE pee.element_entry_id=c_element_entry_id
318: and prr.run_result_id = pee.source_id

Line 334: pay_assignment_actions paa,

330:
331: SELECT ptp.start_date
332: FROM per_time_periods ptp,
333: pay_payroll_actions ppa,
334: pay_assignment_actions paa,
335: pay_run_results prr,
336: pay_element_entries_f pee
337: WHERE pee.element_entry_id=c_element_entry_id
338: and prr.run_result_id = pee.source_id

Line 353: pay_assignment_actions paa,

349: ) is
350: SELECT ptp.start_date
351: FROM per_time_periods ptp,
352: pay_payroll_actions ppa,
353: pay_assignment_actions paa,
354: pay_element_entries_f pee
355: WHERE pee.element_entry_id=c_element_entry_id
356: and paa.assignment_action_id=pee.source_asg_action_id
357: and ppa.payroll_action_id=paa.payroll_action_id

Line 1366: pay_assignment_actions paa,

1362: cursor csr_get_retro_bal_val IS
1363: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1364: from
1365: pay_payroll_actions ppa,
1366: pay_assignment_actions paa,
1367: pay_run_results prr,
1368: pay_run_result_values prv,
1369: pay_element_types_f pet,
1370: pay_element_classifications pec,

Line 1411: pay_assignment_actions paa,

1407: CURSOR csr_retro_bal_val IS
1408: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1409: from
1410: pay_payroll_actions ppa,
1411: pay_assignment_actions paa,
1412: pay_run_results prr,
1413: pay_run_result_values prv,
1414: pay_element_types_f pet,
1415: pay_element_classifications pec,

Line 1440: -- pay_assignment_actions paa1

1436: -- and ppa.payroll_action_id=nvl(p_pact_id,ppa.payroll_action_id)
1437: and paa.assignment_action_id= p_assact_id;
1438:
1439: -- (select max(paa1.assignment_action_id) from
1440: -- pay_assignment_actions paa1
1441: -- where
1442: -- paa1.payroll_action_id=ppa.payroll_action_id
1443: -- and paa1.assignment_id=paa.assignment_id);
1444:

Line 1467: pay_assignment_actions paa,

1463: CURSOR csr_retro_element_context IS
1464: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1465: from
1466: pay_payroll_actions ppa,
1467: pay_assignment_actions paa,
1468: pay_run_results prr,
1469: pay_run_result_values prv,
1470: pay_run_result_values prv1,
1471: pay_action_contexts pac,

Line 1499: pay_assignment_actions paa,

1495: CURSOR csr_retro_element IS
1496: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1497: from
1498: pay_payroll_actions ppa,
1499: pay_assignment_actions paa,
1500: pay_run_results prr,
1501: pay_run_result_values prv,
1502: pay_input_values_f piv
1503: Where

Line 1548: pay_assignment_actions paa,

1544: cursor csr_get_elmt_bal_val IS
1545: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1546: from
1547: pay_payroll_actions ppa,
1548: pay_assignment_actions paa,
1549: pay_run_results prr,
1550: pay_run_result_values prv,
1551: pay_element_types_f pet,
1552: pay_element_classifications pec,

Line 1703: pay_assignment_actions paa,

1699: cursor csr_get_elmt_bal_val is
1700: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1701: from
1702: pay_payroll_actions ppa,
1703: pay_assignment_actions paa,
1704: pay_run_results prr,
1705: pay_run_result_values prv,
1706: pay_element_types_f pet,
1707: pay_element_classifications pec,

Line 1814: FROM pay_assignment_actions paa1

1810: ,c_start_date DATE
1811: ,c_end_date DATE)IS
1812: SELECT 'DP' FROM dual
1813: WHERE EXISTS (SELECT 1
1814: FROM pay_assignment_actions paa1
1815: ,pay_assignment_actions paa2
1816: ,pay_payroll_actions ppa
1817: WHERE paa1.assignment_action_id = c_assignment_action_id
1818: AND paa2.assignment_id = c_assignment_id

Line 1815: ,pay_assignment_actions paa2

1811: ,c_end_date DATE)IS
1812: SELECT 'DP' FROM dual
1813: WHERE EXISTS (SELECT 1
1814: FROM pay_assignment_actions paa1
1815: ,pay_assignment_actions paa2
1816: ,pay_payroll_actions ppa
1817: WHERE paa1.assignment_action_id = c_assignment_action_id
1818: AND paa2.assignment_id = c_assignment_id
1819: AND paa1.tax_unit_id = paa2.tax_unit_id

Line 1832: FROM pay_assignment_actions paa

1828: ,c_start_date DATE
1829: ,c_end_date DATE)IS
1830: SELECT 'DE' FROM dual
1831: WHERE EXISTS (SELECT 1
1832: FROM pay_assignment_actions paa
1833: ,pay_payroll_actions ppa
1834: WHERE paa.assignment_id = c_assignment_id
1835: AND ppa.payroll_action_id = paa.payroll_action_id
1836: AND ppa.action_type IN ('Q','R')

Line 2000: FROM pay_assignment_actions paa1

1996: ,c_start_date DATE
1997: ,c_end_date DATE)IS
1998: SELECT 'DP' FROM dual
1999: WHERE EXISTS (SELECT 1
2000: FROM pay_assignment_actions paa1
2001: ,pay_assignment_actions paa2
2002: ,pay_payroll_actions ppa
2003: WHERE paa1.assignment_action_id = c_assignment_action_id
2004: AND paa2.assignment_id = c_assignment_id

Line 2001: ,pay_assignment_actions paa2

1997: ,c_end_date DATE)IS
1998: SELECT 'DP' FROM dual
1999: WHERE EXISTS (SELECT 1
2000: FROM pay_assignment_actions paa1
2001: ,pay_assignment_actions paa2
2002: ,pay_payroll_actions ppa
2003: WHERE paa1.assignment_action_id = c_assignment_action_id
2004: AND paa2.assignment_id = c_assignment_id
2005: AND paa1.tax_unit_id = paa2.tax_unit_id

Line 2018: FROM pay_assignment_actions paa

2014: ,c_start_date DATE
2015: ,c_end_date DATE)IS
2016: SELECT 'DE' FROM dual
2017: WHERE EXISTS (SELECT 1
2018: FROM pay_assignment_actions paa
2019: ,pay_payroll_actions ppa
2020: WHERE paa.assignment_id = c_assignment_id
2021: AND ppa.payroll_action_id = paa.payroll_action_id
2022: AND ppa.action_type IN ('Q','R')

Line 2186: FROM pay_assignment_actions paa1

2182: ,c_start_date DATE
2183: ,c_end_date DATE)IS
2184: SELECT 'DP' FROM dual
2185: WHERE EXISTS (SELECT 1
2186: FROM pay_assignment_actions paa1
2187: ,pay_assignment_actions paa2
2188: ,pay_payroll_actions ppa
2189: WHERE paa1.assignment_action_id = c_assignment_action_id
2190: AND paa2.assignment_id = paa1.assignment_id

Line 2187: ,pay_assignment_actions paa2

2183: ,c_end_date DATE)IS
2184: SELECT 'DP' FROM dual
2185: WHERE EXISTS (SELECT 1
2186: FROM pay_assignment_actions paa1
2187: ,pay_assignment_actions paa2
2188: ,pay_payroll_actions ppa
2189: WHERE paa1.assignment_action_id = c_assignment_action_id
2190: AND paa2.assignment_id = paa1.assignment_id
2191: AND paa1.tax_unit_id = paa2.tax_unit_id

Line 2202: FROM pay_assignment_actions paa1

2198: ,c_start_date DATE
2199: ,c_end_date DATE)IS
2200: SELECT 'DP' FROM dual
2201: WHERE EXISTS (SELECT 1
2202: FROM pay_assignment_actions paa1
2203: ,pay_assignment_actions paa2
2204: ,pay_payroll_actions ppa
2205: WHERE paa1.assignment_action_id = c_assignment_action_id
2206: AND paa2.assignment_id = paa1.assignment_id

Line 2203: ,pay_assignment_actions paa2

2199: ,c_end_date DATE)IS
2200: SELECT 'DP' FROM dual
2201: WHERE EXISTS (SELECT 1
2202: FROM pay_assignment_actions paa1
2203: ,pay_assignment_actions paa2
2204: ,pay_payroll_actions ppa
2205: WHERE paa1.assignment_action_id = c_assignment_action_id
2206: AND paa2.assignment_id = paa1.assignment_id
2207: AND paa1.tax_unit_id = paa2.tax_unit_id

Line 2221: FROM pay_assignment_actions paa1

2217: ,c_start_date DATE
2218: ,c_end_date DATE)IS
2219: SELECT 'DE' FROM dual
2220: WHERE EXISTS (SELECT 1
2221: FROM pay_assignment_actions paa1
2222: ,pay_assignment_actions paa2
2223: ,pay_payroll_actions ppa1
2224: ,pay_payroll_actions ppa2
2225: WHERE ppa1.payroll_action_id = c_payroll_action_id

Line 2222: ,pay_assignment_actions paa2

2218: ,c_end_date DATE)IS
2219: SELECT 'DE' FROM dual
2220: WHERE EXISTS (SELECT 1
2221: FROM pay_assignment_actions paa1
2222: ,pay_assignment_actions paa2
2223: ,pay_payroll_actions ppa1
2224: ,pay_payroll_actions ppa2
2225: WHERE ppa1.payroll_action_id = c_payroll_action_id
2226: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 2242: FROM pay_assignment_actions paa1

2238: ,c_start_date DATE
2239: ,c_end_date DATE)IS
2240: SELECT 'DE' FROM dual
2241: WHERE EXISTS (SELECT 1
2242: FROM pay_assignment_actions paa1
2243: ,pay_assignment_actions paa2
2244: ,pay_payroll_actions ppa1
2245: ,pay_payroll_actions ppa2
2246: WHERE ppa1.payroll_action_id = c_payroll_action_id

Line 2243: ,pay_assignment_actions paa2

2239: ,c_end_date DATE)IS
2240: SELECT 'DE' FROM dual
2241: WHERE EXISTS (SELECT 1
2242: FROM pay_assignment_actions paa1
2243: ,pay_assignment_actions paa2
2244: ,pay_payroll_actions ppa1
2245: ,pay_payroll_actions ppa2
2246: WHERE ppa1.payroll_action_id = c_payroll_action_id
2247: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 2425: FROM pay_assignment_actions paa1

2421: ,c_start_date DATE
2422: ,c_end_date DATE)IS
2423: SELECT 'DP' FROM dual
2424: WHERE EXISTS (SELECT 1
2425: FROM pay_assignment_actions paa1
2426: ,pay_assignment_actions paa2
2427: ,pay_payroll_actions ppa
2428: WHERE paa1.assignment_action_id = c_assignment_action_id
2429: AND paa2.assignment_id = paa1.assignment_id

Line 2426: ,pay_assignment_actions paa2

2422: ,c_end_date DATE)IS
2423: SELECT 'DP' FROM dual
2424: WHERE EXISTS (SELECT 1
2425: FROM pay_assignment_actions paa1
2426: ,pay_assignment_actions paa2
2427: ,pay_payroll_actions ppa
2428: WHERE paa1.assignment_action_id = c_assignment_action_id
2429: AND paa2.assignment_id = paa1.assignment_id
2430: AND paa1.tax_unit_id = paa2.tax_unit_id

Line 2441: FROM pay_assignment_actions paa1

2437: ,c_start_date DATE
2438: ,c_end_date DATE)IS
2439: SELECT 'DP' FROM dual
2440: WHERE EXISTS (SELECT 1
2441: FROM pay_assignment_actions paa1
2442: ,pay_assignment_actions paa2
2443: ,pay_payroll_actions ppa
2444: WHERE paa1.assignment_action_id = c_assignment_action_id
2445: AND paa2.assignment_id = paa1.assignment_id

Line 2442: ,pay_assignment_actions paa2

2438: ,c_end_date DATE)IS
2439: SELECT 'DP' FROM dual
2440: WHERE EXISTS (SELECT 1
2441: FROM pay_assignment_actions paa1
2442: ,pay_assignment_actions paa2
2443: ,pay_payroll_actions ppa
2444: WHERE paa1.assignment_action_id = c_assignment_action_id
2445: AND paa2.assignment_id = paa1.assignment_id
2446: AND paa1.tax_unit_id = paa2.tax_unit_id

Line 2460: FROM pay_assignment_actions paa1

2456: ,c_start_date DATE
2457: ,c_end_date DATE)IS
2458: SELECT 'DE' FROM dual
2459: WHERE EXISTS (SELECT 1
2460: FROM pay_assignment_actions paa1
2461: ,pay_assignment_actions paa2
2462: ,pay_payroll_actions ppa1
2463: ,pay_payroll_actions ppa2
2464: WHERE ppa1.payroll_action_id = c_payroll_action_id

Line 2461: ,pay_assignment_actions paa2

2457: ,c_end_date DATE)IS
2458: SELECT 'DE' FROM dual
2459: WHERE EXISTS (SELECT 1
2460: FROM pay_assignment_actions paa1
2461: ,pay_assignment_actions paa2
2462: ,pay_payroll_actions ppa1
2463: ,pay_payroll_actions ppa2
2464: WHERE ppa1.payroll_action_id = c_payroll_action_id
2465: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 2481: FROM pay_assignment_actions paa1

2477: ,c_start_date DATE
2478: ,c_end_date DATE)IS
2479: SELECT 'DE' FROM dual
2480: WHERE EXISTS (SELECT 1
2481: FROM pay_assignment_actions paa1
2482: ,pay_assignment_actions paa2
2483: ,pay_payroll_actions ppa1
2484: ,pay_payroll_actions ppa2
2485: WHERE ppa1.payroll_action_id = c_payroll_action_id

Line 2482: ,pay_assignment_actions paa2

2478: ,c_end_date DATE)IS
2479: SELECT 'DE' FROM dual
2480: WHERE EXISTS (SELECT 1
2481: FROM pay_assignment_actions paa1
2482: ,pay_assignment_actions paa2
2483: ,pay_payroll_actions ppa1
2484: ,pay_payroll_actions ppa2
2485: WHERE ppa1.payroll_action_id = c_payroll_action_id
2486: AND ppa1.payroll_action_id = paa1.payroll_action_id