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.PY_ZA_TAX_REG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 239: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

235: -------------------------------------------------------------------------------
236: -- ptd_value
237: -------------------------------------------------------------------------------
238: FUNCTION ptd_value (
239: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
240: , p_action_period_id IN per_time_periods.time_period_id%TYPE
241: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
242: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
243: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

Line 300: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

296: -------------------------------------------------------------------------------
297: -- mtd_value
298: -------------------------------------------------------------------------------
299: FUNCTION mtd_value (
300: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
301: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
302: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
303: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
304: )

Line 362: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

358: -------------------------------------------------------------------------------
359: -- ytd_value
360: -------------------------------------------------------------------------------
361: FUNCTION ytd_value (
362: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
363: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
364: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
365: )
366: RETURN NUMBER AS

Line 445: , pay_assignment_actions paa2

441: SELECT
442: MAX(paa2.assignment_action_id)
443: FROM
444: pay_run_results prr2
445: , pay_assignment_actions paa2
446: , pay_payroll_actions ppa2
447: WHERE
448: prr2.element_type_id = pet.element_type_id
449: AND prr2.run_result_id = nvl(p_run_result_id, prr2.run_result_id)

Line 725: , p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

721: -- assignment_dys_worked
722: -------------------------------------------------------------------------------
723: FUNCTION assignment_dys_worked (
724: p_asg_tax_status IN hr_lookups.meaning%TYPE
725: , p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
726: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
727: )
728: RETURN NUMBER
729: AS

Line 1432: pay_assignment_actions paa

1428: , pap.per_information1 tax_reference_number
1429: , trunc(months_between(g_period_end_date, pap.date_of_birth)/12) age
1430: , oit.org_information3 cmpy_tax_reference_number
1431: FROM
1432: pay_assignment_actions paa
1433: , pay_payroll_actions ppa
1434: , hr_organization_information oit
1435: , per_assignment_extra_info aei
1436: , per_assignments_f asg

Line 1446: (select rowid from pay_assignment_actions paa2 where

1442: AND ppa.time_period_id <= p_end_period_id
1443: AND ppa.payroll_action_id = paa.payroll_action_id
1444: AND paa.assignment_id = nvl(p_asg_id, paa.assignment_id)
1445: AND paa.rowid =
1446: (select rowid from pay_assignment_actions paa2 where
1447: paa2.assignment_id=paa.assignment_id
1448: and paa2.action_sequence=
1449: (select MAX(paa3.action_sequence) from pay_assignment_actions paa3,
1450: pay_payroll_actions ppa2

Line 1449: (select MAX(paa3.action_sequence) from pay_assignment_actions paa3,

1445: AND paa.rowid =
1446: (select rowid from pay_assignment_actions paa2 where
1447: paa2.assignment_id=paa.assignment_id
1448: and paa2.action_sequence=
1449: (select MAX(paa3.action_sequence) from pay_assignment_actions paa3,
1450: pay_payroll_actions ppa2
1451: where paa3.assignment_id = paa.assignment_id
1452: and paa3.payroll_action_id = ppa2.payroll_action_id
1453: and ppa2.action_type IN ('R', 'Q', 'I', 'B', 'V')

Line 1490: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

1486: -- assignment action of the assignment within the specified
1487: -- time periods, the tax year
1488: -----------------------------------------------------------
1489: CURSOR csr_irp5_balances (
1490: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1491: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1492: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1493: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1494: )

Line 1491: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE

1487: -- time periods, the tax year
1488: -----------------------------------------------------------
1489: CURSOR csr_irp5_balances (
1490: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1491: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1492: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1493: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1494: )
1495: IS

Line 1505: , pay_assignment_actions paa

1501: , pay_run_result_values prrv
1502: , pay_run_results prr
1503: , pay_balance_feeds_f feed
1504: , pay_payroll_actions ppa
1505: , pay_assignment_actions paa
1506: WHERE prrv.input_value_id = feed.input_value_id
1507: AND prr.run_result_id = prrv.run_result_id
1508: AND paa.assignment_action_id <= p_asg_action_id
1509: AND prr.assignment_action_id = paa.assignment_action_id