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 41: to add a join on the pay_assignment_actions.action_sequence

37: P Arusia 25/02/2010 115.26 9369937 Resetting the user table t_code_val
38: for each assignment
39: P Arusia 02/12/2009 115.25 9117260 Changes for Tax Year 2010
40: R Babla 23/02/2009 115.24 8274764 Modified cursor csr_irp5_balances
41: to add a join on the pay_assignment_actions.action_sequence
42: and cursor csr_processed_assignments to select
43: the action_sequence
44: R Babla 30/01/2009 115.23 8213478 Modifed the cursor csr_irp5_balances
45: to include the code 4005 with

Line 294: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

290: -------------------------------------------------------------------------------
291: -- ptd_value
292: -------------------------------------------------------------------------------
293: FUNCTION ptd_value (
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

Line 356: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

352: -------------------------------------------------------------------------------
353: -- mtd_value
354: -------------------------------------------------------------------------------
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: )

Line 419: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

415: -------------------------------------------------------------------------------
416: -- ytd_value
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

Line 502: , pay_assignment_actions paa2

498: SELECT
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)

Line 782: , p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

778: -- assignment_dys_worked
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

Line 1481: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804

1477: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1478: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
1479: , p_tot_employees OUT NOCOPY NUMBER
1480: , p_tot_assignments OUT NOCOPY NUMBER
1481: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804
1482: )
1483: AS
1484: -----------------------------------------------------------------
1485: -- Cursor csr_processed_assignments

Line 1514: pay_assignment_actions paa

1510: , pap.per_information1 tax_reference_number
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

Line 1528: (select rowid from pay_assignment_actions paa2 where

1524: AND ppa.time_period_id <= p_end_period_id
1525: AND ppa.payroll_action_id = paa.payroll_action_id
1526: AND paa.assignment_id = nvl(p_asg_id, paa.assignment_id)
1527: AND paa.rowid =
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

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

1527: AND paa.rowid =
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')

Line 1572: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

1568: -- assignment action of the assignment within the specified
1569: -- time periods, the tax year
1570: -----------------------------------------------------------
1571: CURSOR csr_irp5_balances (
1572: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1573: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
1574: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1575: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1576: , p_end_period_id IN per_time_periods.time_period_id%TYPE

Line 1573: p_action_seq IN pay_assignment_actions.action_sequence%TYPE

1569: -- time periods, the tax year
1570: -----------------------------------------------------------
1571: CURSOR csr_irp5_balances (
1572: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1573: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
1574: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1575: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1576: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1577: )

Line 1574: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE

1570: -----------------------------------------------------------
1571: CURSOR csr_irp5_balances (
1572: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1573: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
1574: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1575: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1576: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1577: )
1578: IS

Line 1588: , pay_assignment_actions paa

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
1592: AND paa.action_sequence < = p_action_seq

Line 2184: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804

2180: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
2181: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
2182: , p_tot_employees OUT NOCOPY NUMBER
2183: , p_tot_assignments OUT NOCOPY NUMBER
2184: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804
2185: )
2186: AS
2187: -----------------------------------------------------------------
2188: -- Cursor csr_processed_assignments

Line 2217: pay_assignment_actions paa

2213: , pap.per_information1 tax_reference_number
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

Line 2231: (select rowid from pay_assignment_actions paa2 where

2227: AND ppa.time_period_id <= p_end_period_id
2228: AND ppa.payroll_action_id = paa.payroll_action_id
2229: AND paa.assignment_id = nvl(p_asg_id, paa.assignment_id)
2230: AND paa.rowid =
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

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

2230: AND paa.rowid =
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')

Line 2277: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE

2273: -- assignment action of the assignment within the specified
2274: -- time periods, the tax year
2275: -----------------------------------------------------------
2276: CURSOR csr_irp5_balances (
2277: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
2278: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
2279: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
2280: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2281: , p_end_period_id IN per_time_periods.time_period_id%TYPE

Line 2278: p_action_seq IN pay_assignment_actions.action_sequence%TYPE

2274: -- time periods, the tax year
2275: -----------------------------------------------------------
2276: CURSOR csr_irp5_balances (
2277: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
2278: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
2279: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
2280: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2281: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2282: )

Line 2279: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE

2275: -----------------------------------------------------------
2276: CURSOR csr_irp5_balances (
2277: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
2278: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
2279: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
2280: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2281: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2282: )
2283: IS

Line 2293: , pay_assignment_actions paa

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
2297: AND paa.action_sequence < = p_action_seq

Line 2322: , pay_assignment_actions paa

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
2326: AND prr.assignment_action_id = paa.assignment_action_id