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_AU_PAYE_FF dependencies on PAY_PAYROLL_ACTIONS

Line 347: from pay_payroll_actions ppa,

343: CURSOR csr_get_pay_dates
344: IS
345: select ppa.date_earned,
346: ppa.effective_date
347: from pay_payroll_actions ppa,
348: pay_assignment_actions paa
349: where ppa.payroll_action_id = paa.payroll_action_id
350: and paa.assignment_action_id = p_assignment_action_id;
351:

Line 562: ,pay_payroll_actions ppa

558: c_fin_end_date in date)
559: IS
560: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id
561: FROM pay_assignment_actions paa
562: ,pay_payroll_actions ppa
563: WHERE paa.assignment_id = c_assignment_id
564: and ppa.payroll_action_id = paa.payroll_action_id
565: and ppa.business_group_id = c_business_group_id
566: AND paa.action_sequence in

Line 570: pay_payroll_actions ppa,

566: AND paa.action_sequence in
567: (
568: SELECT MAX(paa.action_sequence)
569: FROM pay_assignment_actions paa,
570: pay_payroll_actions ppa,
571: per_all_assignments_f paaf
572: WHERE ppa.business_group_id = c_business_group_id
573: AND paaf.assignment_id = c_assignment_id
574: AND paa.assignment_id = paaf.assignment_id

Line 592: ,pay_payroll_actions ppa

588: c_fin_end_date in date)
589: IS
590: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id, ppa.effective_date
591: FROM pay_assignment_actions paa
592: ,pay_payroll_actions ppa
593: WHERE paa.assignment_id = c_assignment_id
594: and ppa.payroll_action_id = paa.payroll_action_id
595: and ppa.business_group_id = c_business_group_id
596: AND paa.action_sequence in

Line 600: pay_payroll_actions ppa,

596: AND paa.action_sequence in
597: (
598: SELECT MAX(paa.action_sequence)
599: FROM pay_assignment_actions paa,
600: pay_payroll_actions ppa,
601: per_all_assignments_f paaf
602: WHERE ppa.business_group_id = c_business_group_id
603: AND paaf.assignment_id = c_assignment_id
604: AND paa.action_status='C'

Line 655: FROM pay_payroll_actions ppa,

651:
652: CURSOR c_get_payroll_effective_date
653: IS
654: SELECT ppa.effective_date
655: FROM pay_payroll_actions ppa,
656: pay_assignment_actions paa
657: WHERE paa.assignment_action_id = p_assignment_action_id
658: AND ppa.payroll_action_id = paa.payroll_action_id;
659:

Line 669: pay_payroll_actions ppa,

665: c_end_date in date)
666: IS
667: SELECT count(paa.assignment_action_id)
668: FROM pay_assignment_actions paa,
669: pay_payroll_actions ppa,
670: per_assignments_f paf
671: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
672: AND ppa.business_group_id = c_business_group_id
673: AND ppa.payroll_action_id = paa.payroll_action_id

Line 991: pay_payroll_actions ppa,

987: select DISTINCT ptp.time_period_id, ptp.period_num /*Bug 4438644*/
988: from per_time_periods ptp
989: where exists (select 'EXISTS' from
990: per_assignments_f paf,
991: pay_payroll_actions ppa,
992: pay_assignment_actions paa
993: where ppa.payroll_id = v_payroll_id
994: and ppa.action_type in ('R','Q')
995: and paa.action_status = 'C'

Line 1013: FROM pay_payroll_actions ppa,

1009:
1010: CURSOR c_get_payroll_effective_date
1011: IS
1012: SELECT ppa.effective_date
1013: FROM pay_payroll_actions ppa,
1014: pay_assignment_actions paa
1015: WHERE paa.assignment_action_id = p_assignment_action_id
1016: AND ppa.payroll_action_id = paa.payroll_action_id;
1017:

Line 1179: p_date_earned in pay_payroll_actions.date_earned%TYPE

1175:
1176: function check_if_retro
1177: (
1178: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1179: p_date_earned in pay_payroll_actions.date_earned%TYPE
1180:
1181: )return varchar2 is
1182:
1183:

Line 1225: p_date_earned in pay_payroll_actions.date_earned%TYPE,

1221:
1222: function get_retro_period
1223: (
1224: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1225: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1226: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,/*Bug 4418107*/
1227: p_retro_start_date out NOCOPY date,
1228: p_retro_end_date out NOCOPY date
1229: )return number is

Line 1234: c_date_earned in pay_payroll_actions.date_earned%TYPE

1230:
1231:
1232: cursor get_retro_period_rr
1233: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1234: c_date_earned in pay_payroll_actions.date_earned%TYPE
1235: ) is
1236: SELECT ptp.start_date,ptp.end_date
1237: FROM per_time_periods ptp,
1238: pay_payroll_actions ppa,

Line 1238: pay_payroll_actions ppa,

1234: c_date_earned in pay_payroll_actions.date_earned%TYPE
1235: ) is
1236: SELECT ptp.start_date,ptp.end_date
1237: FROM per_time_periods ptp,
1238: pay_payroll_actions ppa,
1239: pay_assignment_actions paa,
1240: pay_run_results prr,
1241: pay_element_entries_f pee
1242: WHERE pee.element_entry_id=c_element_entry_id

Line 1256: c_date_earned in pay_payroll_actions.date_earned%TYPE

1252:
1253:
1254: cursor get_retro_period_ee
1255: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1256: c_date_earned in pay_payroll_actions.date_earned%TYPE
1257: ) is
1258: SELECT ptp.start_date,ptp.end_date
1259: FROM per_time_periods ptp,
1260: pay_payroll_actions ppa,

Line 1260: pay_payroll_actions ppa,

1256: c_date_earned in pay_payroll_actions.date_earned%TYPE
1257: ) is
1258: SELECT ptp.start_date,ptp.end_date
1259: FROM per_time_periods ptp,
1260: pay_payroll_actions ppa,
1261: pay_assignment_actions paa,
1262: pay_element_entries_f pee
1263: WHERE pee.element_entry_id=c_element_entry_id
1264: and paa.assignment_action_id=pee.source_asg_action_id

Line 1348: p_date_earned IN pay_payroll_actions.date_earned%TYPE,

1344:
1345: FUNCTION get_enhanced_retro_period
1346: (
1347: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
1348: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
1349: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1350: p_retro_start_date OUT NOCOPY date,
1351: p_retro_end_date OUT NOCOPY date,
1352: p_orig_effective_date OUT NOCOPY date,

Line 1366: FROM pay_payroll_actions ppa,

1362: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE)
1363: IS
1364: SELECT pee.creator_type,
1365: ppa.effective_date
1366: FROM pay_payroll_actions ppa,
1367: pay_assignment_actions paa,
1368: pay_element_entries_f pee
1369: WHERE ppa.payroll_action_id = paa.payroll_action_id
1370: AND paa.assignment_action_id = pee.creator_id

Line 1376: c_date_earned in pay_payroll_actions.date_earned%TYPE

1372: AND ppa.action_type ='L';
1373:
1374: CURSOR get_retro_period_rr
1375: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1376: c_date_earned in pay_payroll_actions.date_earned%TYPE
1377: )
1378: IS
1379: SELECT ptp.start_date
1380: ,ptp.end_date

Line 1383: pay_payroll_actions ppa,

1379: SELECT ptp.start_date
1380: ,ptp.end_date
1381: ,ppa.effective_date
1382: FROM per_time_periods ptp,
1383: pay_payroll_actions ppa,
1384: pay_assignment_actions paa,
1385: pay_run_results prr,
1386: pay_element_entries_f pee
1387: WHERE pee.element_entry_id=c_element_entry_id

Line 1400: c_date_earned in pay_payroll_actions.date_earned%TYPE

1396:
1397:
1398: CURSOR get_retro_period_ee
1399: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1400: c_date_earned in pay_payroll_actions.date_earned%TYPE
1401: )
1402: IS
1403: SELECT ptp.start_date
1404: ,ptp.end_date

Line 1407: pay_payroll_actions ppa,

1403: SELECT ptp.start_date
1404: ,ptp.end_date
1405: ,ppa.effective_date
1406: FROM per_time_periods ptp,
1407: pay_payroll_actions ppa,
1408: pay_assignment_actions paa,
1409: pay_element_entries_f pee
1410: WHERE pee.element_entry_id=c_element_entry_id
1411: AND paa.assignment_action_id=pee.source_asg_action_id

Line 1578: p_date_earned IN pay_payroll_actions.date_earned%TYPE,

1574:
1575: FUNCTION get_retro_time_span
1576: (
1577: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
1578: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
1579: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1580: p_retro_start_date OUT NOCOPY date,
1581: p_retro_end_date OUT NOCOPY date,
1582: p_orig_effective_date OUT NOCOPY date,

Line 1591: ,c_date_earned pay_payroll_actions.date_earned%TYPE)

1587: IS
1588:
1589: CURSOR get_retro_entry_details
1590: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1591: ,c_date_earned pay_payroll_actions.date_earned%TYPE)
1592: IS
1593: SELECT pee.element_entry_id
1594: ,ppa.retro_definition_id
1595: ,pepd.retro_component_id

Line 1598: ,pay_payroll_actions ppa

1594: ,ppa.retro_definition_id
1595: ,pepd.retro_component_id
1596: FROM pay_element_entries_f pee
1597: ,pay_assignment_actions paa
1598: ,pay_payroll_actions ppa
1599: ,pay_entry_process_details pepd
1600: WHERE pee.element_entry_id = c_element_entry_id
1601: AND pee.element_entry_id = pepd.element_entry_id
1602: AND pee.creator_id = paa.assignment_action_id

Line 1710: p_date_earned in pay_payroll_actions.date_earned%TYPE,

1706:
1707: function count_retro_periods
1708: (
1709: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1710: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1711: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
1712: p_use_tax_flag IN VARCHAR2 --4415795
1713: )return number
1714: is

Line 1769: FROM pay_payroll_actions ppa

1765: /* Bug 6139035 - Cursor to fetch Effective Date */
1766: CURSOR c_get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1767: IS
1768: SELECT ppa.effective_date
1769: FROM pay_payroll_actions ppa
1770: ,pay_assignment_actions paa
1771: WHERE paa.assignment_action_id = c_assignment_action_id
1772: AND paa.payroll_action_id = ppa.payroll_action_id;
1773:

Line 1999: function calculate_tax(p_date_earned in pay_payroll_actions.date_earned%TYPE,

1995: end count_retro_periods;
1996:
1997:
1998:
1999: function calculate_tax(p_date_earned in pay_payroll_actions.date_earned%TYPE,
2000: p_period_amount in number,
2001: p_period_frequency in number,
2002: p_tax_scale in number,
2003: p_a1_variable in number,

Line 2065: pay_payroll_actions ppa,

2061: pay_input_values_f piv,
2062: pay_run_result_values prrv,
2063: pay_run_results prr,
2064: pay_assignment_actions paa,
2065: pay_payroll_actions ppa,
2066: per_time_periods ptp,
2067: per_all_assignments_f paaf
2068: where pet.element_name = 'Extra Withholding Payments'
2069: and piv.name='Withholding Amount'

Line 2091: pay_payroll_actions ppa1,

2087: /* Bug 4374115 - Start */
2088: and not exists(
2089: select pai.locking_action_id
2090: from pay_assignment_actions paa1,
2091: pay_payroll_actions ppa1,
2092: pay_action_interlocks pai
2093: where ppa1.payroll_action_id = paa1.payroll_action_id
2094: and ppa1.action_type = 'V'
2095: and paa1.assignment_id = p_assignment_id

Line 2377: pay_payroll_actions ppa

2373: CURSOR Cr_action IS
2374: select INTLK.locking_action_id
2375: from pay_action_interlocks INTLK,
2376: pay_assignment_actions paa,
2377: pay_payroll_actions ppa
2378: where INTLK.locked_action_id = p_action_id
2379: and INTLK.locking_action_id = paa.assignment_action_id
2380: and paa.payroll_action_id = ppa.payroll_action_id
2381: and ppa.action_type in ('P', 'U')