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_PAYROLL_ACTIONS

Line 243: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

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
244: )
245: RETURN NUMBER AS
246: ------------
247: -- Variables

Line 303: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

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: )
305: RETURN NUMBER AS
306: ------------
307: -- Variables

Line 364: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

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
367: ------------
368: -- Variables

Line 446: , pay_payroll_actions ppa2

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)
450: AND prr2.assignment_action_id = paa2.assignment_action_id

Line 726: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

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
730: ------------

Line 1433: , pay_payroll_actions ppa

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
1437: , per_people_f pap

Line 1450: pay_payroll_actions ppa2

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')
1454: and ppa2.time_period_id <= p_end_period_id

Line 1504: , pay_payroll_actions ppa

1500: FROM pay_za_irp5_bal_codes pbc
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