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 298: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

294: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
295: , p_action_period_id IN per_time_periods.time_period_id%TYPE
296: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
297: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
298: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
299: )
300: RETURN NUMBER AS
301: ------------
302: -- Variables

Line 359: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

355: FUNCTION mtd_value (
356: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
357: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
358: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
359: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
360: )
361: RETURN NUMBER AS
362: ------------
363: -- Variables

Line 421: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

417: -------------------------------------------------------------------------------
418: FUNCTION ytd_value (
419: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
420: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
421: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
422: )
423: RETURN NUMBER AS
424: ------------
425: -- Variables

Line 503: , pay_payroll_actions ppa2

499: MAX(paa2.assignment_action_id)
500: FROM
501: pay_run_results prr2
502: , pay_assignment_actions paa2
503: , pay_payroll_actions ppa2
504: WHERE
505: prr2.element_type_id = pet.element_type_id
506: AND prr2.run_result_id = nvl(p_run_result_id, prr2.run_result_id)
507: AND prr2.assignment_action_id = paa2.assignment_action_id

Line 783: , p_effective_date IN pay_payroll_actions.effective_date%TYPE

779: -------------------------------------------------------------------------------
780: FUNCTION assignment_dys_worked (
781: p_asg_tax_status IN hr_lookups.meaning%TYPE
782: , p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
783: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
784: )
785: RETURN NUMBER
786: AS
787: ------------

Line 1515: , pay_payroll_actions ppa

1511: , trunc(months_between(g_period_end_date, pap.date_of_birth)/12) age
1512: , oit.org_information3 cmpy_tax_reference_number
1513: FROM
1514: pay_assignment_actions paa
1515: , pay_payroll_actions ppa
1516: , hr_organization_information oit
1517: , per_assignment_extra_info aei
1518: , per_assignments_f asg
1519: , per_people_f pap

Line 1532: pay_payroll_actions ppa2

1528: (select rowid from pay_assignment_actions paa2 where
1529: paa2.assignment_id=paa.assignment_id
1530: and paa2.action_sequence=
1531: (select MAX(paa3.action_sequence) from pay_assignment_actions paa3,
1532: pay_payroll_actions ppa2
1533: where paa3.assignment_id = paa.assignment_id
1534: and paa3.payroll_action_id = ppa2.payroll_action_id
1535: and ppa2.action_type IN ('R', 'Q', 'I', 'B', 'V')
1536: and ppa2.time_period_id <= p_end_period_id

Line 1587: , pay_payroll_actions ppa

1583: FROM pay_za_irp5_bal_codes pbc
1584: , pay_run_result_values prrv
1585: , pay_run_results prr
1586: , pay_balance_feeds_f feed
1587: , pay_payroll_actions ppa
1588: , pay_assignment_actions paa
1589: WHERE prrv.input_value_id = feed.input_value_id
1590: AND prr.run_result_id = prrv.run_result_id
1591: -- AND paa.assignment_action_id <= p_asg_action_id

Line 2218: , pay_payroll_actions ppa

2214: , trunc(months_between(g_period_end_date, pap.date_of_birth)/12) age
2215: , oit.org_information3 cmpy_tax_reference_number
2216: FROM
2217: pay_assignment_actions paa
2218: , pay_payroll_actions ppa
2219: , hr_organization_information oit
2220: , per_assignment_extra_info aei
2221: , per_assignments_f asg
2222: , per_people_f pap

Line 2235: pay_payroll_actions ppa2

2231: (select rowid from pay_assignment_actions paa2 where
2232: paa2.assignment_id=paa.assignment_id
2233: and paa2.action_sequence=
2234: (select MAX(paa3.action_sequence) from pay_assignment_actions paa3,
2235: pay_payroll_actions ppa2
2236: where paa3.assignment_id = paa.assignment_id
2237: and paa3.payroll_action_id = ppa2.payroll_action_id
2238: and ppa2.action_type IN ('R', 'Q', 'I', 'B', 'V')
2239: and ppa2.time_period_id >= p_start_period_id

Line 2292: , pay_payroll_actions ppa

2288: FROM pay_za_irp5_bal_codes pbc
2289: , pay_run_result_values prrv
2290: , pay_run_results prr
2291: , pay_balance_feeds_f feed
2292: , pay_payroll_actions ppa
2293: , pay_assignment_actions paa
2294: WHERE prrv.input_value_id = feed.input_value_id
2295: AND prr.run_result_id = prrv.run_result_id
2296: -- AND paa.assignment_action_id <= p_asg_action_id

Line 2321: , pay_payroll_actions ppa

2317: FROM pay_balance_types pbt
2318: , pay_run_result_values prrv
2319: , pay_run_results prr
2320: , pay_balance_feeds_f feed
2321: , pay_payroll_actions ppa
2322: , pay_assignment_actions paa
2323: WHERE prrv.input_value_id = feed.input_value_id
2324: AND prr.run_result_id = prrv.run_result_id
2325: AND paa.action_sequence < = p_action_seq