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 509: from pay_payroll_actions ppa,

505: CURSOR csr_get_pay_dates
506: IS
507: select ppa.date_earned,
508: ppa.effective_date
509: from pay_payroll_actions ppa,
510: pay_assignment_actions paa
511: where ppa.payroll_action_id = paa.payroll_action_id
512: and paa.assignment_action_id = p_assignment_action_id;
513:

Line 732: ,pay_payroll_actions ppa

728: c_fin_end_date in date)
729: IS
730: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id
731: FROM pay_assignment_actions paa
732: ,pay_payroll_actions ppa
733: WHERE paa.assignment_id = c_assignment_id
734: and ppa.payroll_action_id = paa.payroll_action_id
735: and ppa.business_group_id = c_business_group_id
736: AND paa.action_sequence in

Line 740: pay_payroll_actions ppa,

736: AND paa.action_sequence in
737: (
738: SELECT MAX(paa.action_sequence)
739: FROM pay_assignment_actions paa,
740: pay_payroll_actions ppa,
741: per_all_assignments_f paaf
742: WHERE ppa.business_group_id = c_business_group_id
743: AND paaf.assignment_id = c_assignment_id
744: AND paa.assignment_id = paaf.assignment_id

Line 762: ,pay_payroll_actions ppa

758: c_fin_end_date in date)
759: IS
760: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id, ppa.effective_date
761: FROM pay_assignment_actions paa
762: ,pay_payroll_actions ppa
763: WHERE paa.assignment_id = c_assignment_id
764: and ppa.payroll_action_id = paa.payroll_action_id
765: and ppa.business_group_id = c_business_group_id
766: AND paa.action_sequence in

Line 770: pay_payroll_actions ppa,

766: AND paa.action_sequence in
767: (
768: SELECT MAX(paa.action_sequence)
769: FROM pay_assignment_actions paa,
770: pay_payroll_actions ppa,
771: per_all_assignments_f paaf
772: WHERE ppa.business_group_id = c_business_group_id
773: AND paaf.assignment_id = c_assignment_id
774: AND paa.action_status='C'

Line 870: FROM pay_payroll_actions ppa,

866:
867: CURSOR c_get_payroll_effective_date
868: IS
869: SELECT ppa.effective_date
870: FROM pay_payroll_actions ppa,
871: pay_assignment_actions paa
872: WHERE paa.assignment_action_id = p_assignment_action_id
873: AND ppa.payroll_action_id = paa.payroll_action_id;
874:

Line 884: pay_payroll_actions ppa,

880: c_end_date in date)
881: IS
882: SELECT count(paa.assignment_action_id)
883: FROM pay_assignment_actions paa,
884: pay_payroll_actions ppa,
885: per_assignments_f paf
886: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
887: AND ppa.business_group_id = c_business_group_id
888: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1242: pay_payroll_actions ppa,

1238: select DISTINCT ptp.time_period_id, ptp.period_num /*Bug 4438644*/
1239: from per_time_periods ptp
1240: where exists (select 'EXISTS' from
1241: per_assignments_f paf,
1242: pay_payroll_actions ppa,
1243: pay_assignment_actions paa
1244: where ppa.payroll_id = v_payroll_id
1245: and ppa.action_type in ('R','Q')
1246: and paa.action_status = 'C'

Line 1264: FROM pay_payroll_actions ppa,

1260:
1261: CURSOR c_get_payroll_effective_date
1262: IS
1263: SELECT ppa.effective_date
1264: FROM pay_payroll_actions ppa,
1265: pay_assignment_actions paa
1266: WHERE paa.assignment_action_id = p_assignment_action_id
1267: AND ppa.payroll_action_id = paa.payroll_action_id;
1268:

Line 1430: p_date_earned in pay_payroll_actions.date_earned%TYPE

1426:
1427: function check_if_retro
1428: (
1429: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1430: p_date_earned in pay_payroll_actions.date_earned%TYPE
1431:
1432: )return varchar2 is
1433:
1434:

Line 1476: p_date_earned in pay_payroll_actions.date_earned%TYPE,

1472:
1473: function get_retro_period
1474: (
1475: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1476: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1477: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,/*Bug 4418107*/
1478: p_retro_start_date out NOCOPY date,
1479: p_retro_end_date out NOCOPY date
1480: )return number is

Line 1485: c_date_earned in pay_payroll_actions.date_earned%TYPE

1481:
1482:
1483: cursor get_retro_period_rr
1484: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1485: c_date_earned in pay_payroll_actions.date_earned%TYPE
1486: ) is
1487: SELECT ptp.start_date,ptp.end_date
1488: FROM per_time_periods ptp,
1489: pay_payroll_actions ppa,

Line 1489: pay_payroll_actions ppa,

1485: c_date_earned in pay_payroll_actions.date_earned%TYPE
1486: ) is
1487: SELECT ptp.start_date,ptp.end_date
1488: FROM per_time_periods ptp,
1489: pay_payroll_actions ppa,
1490: pay_assignment_actions paa,
1491: pay_run_results prr,
1492: pay_element_entries_f pee
1493: WHERE pee.element_entry_id=c_element_entry_id

Line 1507: c_date_earned in pay_payroll_actions.date_earned%TYPE

1503:
1504:
1505: cursor get_retro_period_ee
1506: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1507: c_date_earned in pay_payroll_actions.date_earned%TYPE
1508: ) is
1509: SELECT ptp.start_date,ptp.end_date
1510: FROM per_time_periods ptp,
1511: pay_payroll_actions ppa,

Line 1511: pay_payroll_actions ppa,

1507: c_date_earned in pay_payroll_actions.date_earned%TYPE
1508: ) is
1509: SELECT ptp.start_date,ptp.end_date
1510: FROM per_time_periods ptp,
1511: pay_payroll_actions ppa,
1512: pay_assignment_actions paa,
1513: pay_element_entries_f pee
1514: WHERE pee.element_entry_id=c_element_entry_id
1515: and paa.assignment_action_id=pee.source_asg_action_id

Line 1599: p_date_earned IN pay_payroll_actions.date_earned%TYPE,

1595:
1596: FUNCTION get_enhanced_retro_period
1597: (
1598: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
1599: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
1600: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1601: p_retro_start_date OUT NOCOPY date,
1602: p_retro_end_date OUT NOCOPY date,
1603: p_orig_effective_date OUT NOCOPY date,

Line 1617: FROM pay_payroll_actions ppa,

1613: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE)
1614: IS
1615: SELECT pee.creator_type,
1616: ppa.effective_date
1617: FROM pay_payroll_actions ppa,
1618: pay_assignment_actions paa,
1619: pay_element_entries_f pee
1620: WHERE ppa.payroll_action_id = paa.payroll_action_id
1621: AND paa.assignment_action_id = pee.creator_id

Line 1627: c_date_earned in pay_payroll_actions.date_earned%TYPE

1623: AND ppa.action_type ='L';
1624:
1625: CURSOR get_retro_period_rr
1626: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1627: c_date_earned in pay_payroll_actions.date_earned%TYPE
1628: )
1629: IS
1630: SELECT ptp.start_date
1631: ,ptp.end_date

Line 1634: pay_payroll_actions ppa,

1630: SELECT ptp.start_date
1631: ,ptp.end_date
1632: ,ppa.effective_date
1633: FROM per_time_periods ptp,
1634: pay_payroll_actions ppa,
1635: pay_assignment_actions paa,
1636: pay_run_results prr,
1637: pay_element_entries_f pee
1638: WHERE pee.element_entry_id=c_element_entry_id

Line 1651: c_date_earned in pay_payroll_actions.date_earned%TYPE

1647:
1648:
1649: CURSOR get_retro_period_ee
1650: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1651: c_date_earned in pay_payroll_actions.date_earned%TYPE
1652: )
1653: IS
1654: SELECT ptp.start_date
1655: ,ptp.end_date

Line 1658: pay_payroll_actions ppa,

1654: SELECT ptp.start_date
1655: ,ptp.end_date
1656: ,ppa.effective_date
1657: FROM per_time_periods ptp,
1658: pay_payroll_actions ppa,
1659: pay_assignment_actions paa,
1660: pay_element_entries_f pee
1661: WHERE pee.element_entry_id=c_element_entry_id
1662: AND paa.assignment_action_id=pee.source_asg_action_id

Line 1829: p_date_earned IN pay_payroll_actions.date_earned%TYPE,

1825:
1826: FUNCTION get_retro_time_span
1827: (
1828: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
1829: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
1830: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1831: p_retro_start_date OUT NOCOPY date,
1832: p_retro_end_date OUT NOCOPY date,
1833: p_orig_effective_date OUT NOCOPY date,

Line 1842: ,c_date_earned pay_payroll_actions.date_earned%TYPE)

1838: IS
1839:
1840: CURSOR get_retro_entry_details
1841: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1842: ,c_date_earned pay_payroll_actions.date_earned%TYPE)
1843: IS
1844: SELECT pee.element_entry_id
1845: ,ppa.retro_definition_id
1846: ,pepd.retro_component_id

Line 1849: ,pay_payroll_actions ppa

1845: ,ppa.retro_definition_id
1846: ,pepd.retro_component_id
1847: FROM pay_element_entries_f pee
1848: ,pay_assignment_actions paa
1849: ,pay_payroll_actions ppa
1850: ,pay_entry_process_details pepd
1851: WHERE pee.element_entry_id = c_element_entry_id
1852: AND pee.element_entry_id = pepd.element_entry_id
1853: AND pee.creator_id = paa.assignment_action_id

Line 1960: p_date_earned in pay_payroll_actions.date_earned%TYPE,

1956:
1957: function count_retro_periods
1958: (
1959: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1960: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1961: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
1962: p_use_tax_flag IN VARCHAR2, --4415795
1963: p_mode IN VARCHAR2 DEFAULT 'E' --7665727
1964: )return number

Line 2020: FROM pay_payroll_actions ppa

2016: /* Bug 6139035 - Cursor to fetch Effective Date */
2017: CURSOR c_get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2018: IS
2019: SELECT ppa.effective_date
2020: FROM pay_payroll_actions ppa
2021: ,pay_assignment_actions paa
2022: WHERE paa.assignment_action_id = c_assignment_action_id
2023: AND paa.payroll_action_id = ppa.payroll_action_id;
2024:

Line 2272: p_date_earned in pay_payroll_actions.date_earned%TYPE,

2268:
2269: function count_retro_periods_2009
2270: (
2271: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
2272: p_date_earned in pay_payroll_actions.date_earned%TYPE,
2273: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
2274: p_use_tax_flag IN VARCHAR2,
2275: p_mode IN VARCHAR2 --7665727
2276: )return number

Line 2395: FROM pay_payroll_actions ppa

2391:
2392: CURSOR c_get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2393: IS
2394: SELECT ppa.effective_date
2395: FROM pay_payroll_actions ppa
2396: ,pay_assignment_actions paa
2397: WHERE paa.assignment_action_id = c_assignment_action_id
2398: AND paa.payroll_action_id = ppa.payroll_action_id;
2399:

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

2743:
2744: end count_retro_periods_2009;
2745:
2746:
2747: function calculate_tax(p_date_earned in pay_payroll_actions.date_earned%TYPE,
2748: p_period_amount in number,
2749: p_period_frequency in number,
2750: p_tax_scale in number,
2751: p_a1_variable in number,

Line 2813: pay_payroll_actions ppa,

2809: pay_input_values_f piv,
2810: pay_run_result_values prrv,
2811: pay_run_results prr,
2812: pay_assignment_actions paa,
2813: pay_payroll_actions ppa,
2814: per_time_periods ptp,
2815: per_all_assignments_f paaf
2816: where pet.element_name = 'Extra Withholding Payments'
2817: and piv.name='Withholding Amount'

Line 2840: pay_payroll_actions ppa1,

2836: /* Bug 4374115 - Start */
2837: and not exists(
2838: select pai.locking_action_id
2839: from pay_assignment_actions paa1,
2840: pay_payroll_actions ppa1,
2841: pay_action_interlocks pai
2842: where ppa1.payroll_action_id = paa1.payroll_action_id
2843: and ppa1.action_type = 'V'
2844: and paa1.assignment_id = p_assignment_id

Line 3126: pay_payroll_actions ppa

3122: CURSOR Cr_action IS
3123: select INTLK.locking_action_id
3124: from pay_action_interlocks INTLK,
3125: pay_assignment_actions paa,
3126: pay_payroll_actions ppa
3127: where INTLK.locked_action_id = p_action_id
3128: and INTLK.locking_action_id = paa.assignment_action_id
3129: and paa.payroll_action_id = ppa.payroll_action_id
3130: and ppa.action_type in ('P', 'U')

Line 3494: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE

3490: /*bug8406009 - calc_average_earnings function to calculate the average earnings.*/
3491: FUNCTION calc_average_earnings
3492: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3493: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
3494: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE
3495: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
3496: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
3497: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
3498: ,p_period_start_date IN DATE

Line 3497: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE

3493: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
3494: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE
3495: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
3496: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
3497: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
3498: ,p_period_start_date IN DATE
3499: ,p_emp_hire_date IN DATE
3500: ,p_earnings_std_ytd IN NUMBER
3501: ,p_earnings_std_ptd IN NUMBER

Line 3554: FROM pay_payroll_actions ppa

3550:
3551: CURSOR c_get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
3552: IS
3553: SELECT ppa.effective_date
3554: FROM pay_payroll_actions ppa
3555: ,pay_assignment_actions paa
3556: WHERE paa.assignment_action_id = c_assignment_action_id
3557: AND paa.payroll_action_id = ppa.payroll_action_id;
3558:

Line 3699: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE

3695: FUNCTION calc_lt12_prev_spread_tax
3696: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3697: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
3698: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
3699: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
3700: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE
3701: ,p_average_earnings IN NUMBER
3702: ,p_tax_scale IN VARCHAR2
3703: ,p_period_frequency IN NUMBER

Line 3700: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE

3696: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3697: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
3698: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
3699: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
3700: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE
3701: ,p_average_earnings IN NUMBER
3702: ,p_tax_scale IN VARCHAR2
3703: ,p_period_frequency IN NUMBER
3704: ,p_spread_tax OUT NOCOPY NUMBER

Line 3712: ,c_date_earned IN pay_payroll_actions.date_earned%TYPE)

3708: RETURN VARCHAR2
3709: IS
3710: CURSOR get_retro_spread_entries
3711: (c_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3712: ,c_date_earned IN pay_payroll_actions.date_earned%TYPE)
3713: IS
3714: SELECT pee.element_entry_id,
3715: peev.screen_entry_value retro_amount,
3716: pee.creator_type

Line 3795: FROM pay_payroll_actions ppa

3791:
3792: CURSOR c_get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
3793: IS
3794: SELECT ppa.effective_date
3795: FROM pay_payroll_actions ppa
3796: ,pay_assignment_actions paa
3797: WHERE paa.assignment_action_id = c_assignment_action_id
3798: AND paa.payroll_action_id = ppa.payroll_action_id;
3799:

Line 4118: , pay_payroll_actions ppa

4114: FROM
4115: pay_balance_feeds_f FEED
4116: , pay_run_result_values TARGET
4117: , pay_run_results prr
4118: , pay_payroll_actions ppa
4119: , pay_assignment_actions paa
4120: , pay_payroll_actions ppas
4121: , pay_assignment_actions paas
4122: where paas.assignment_action_id = c_assignment_action_id

Line 4120: , pay_payroll_actions ppas

4116: , pay_run_result_values TARGET
4117: , pay_run_results prr
4118: , pay_payroll_actions ppa
4119: , pay_assignment_actions paa
4120: , pay_payroll_actions ppas
4121: , pay_assignment_actions paas
4122: where paas.assignment_action_id = c_assignment_action_id
4123: and paas.payroll_action_id = ppas.payroll_action_id
4124: and FEED.input_value_id = TARGET.input_value_id

Line 4342: , pay_payroll_actions ppa

4338: CURSOR csr_max_assgt_action(p_assignment_id IN pay_assignment_actions.assignment_id%TYPE)
4339: IS
4340: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
4341: from pay_assignment_actions paa
4342: , pay_payroll_actions ppa
4343: , per_assignments_f paf
4344: , per_time_periods ptp
4345: where paa.assignment_id = paf.assignment_id
4346: and paf.assignment_id = p_assignment_id