DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_ARCHIVE_PKG dependencies on PAY_ZA_IRP5_ARCHIVE_PKG

Line 1: package body pay_za_irp5_archive_pkg as

1: package body pay_za_irp5_archive_pkg as
2: /* $Header: pyzaarch.pkb 120.14.12010000.2 2008/08/14 07:24:35 rbabla ship $ */
3: sql_range varchar2(4000);
4: prev_asg_id number;
5: g_size number; -- Used to keep track of the size of the IRP5 file

Line 1045: and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR', legislative_parameters) = p_tax_year;

1041: from pay_payroll_actions
1042: where action_type = 'X'
1043: and report_type = 'ZA_IRP5'
1044: and business_group_id = to_number(p_bg_id)
1045: and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR', legislative_parameters) = p_tax_year;
1046:
1047: if l_count = 1 then
1048:
1049: -- Reset the Generation Number to 0

Line 1458: end pay_za_irp5_archive_pkg;

1454:
1455: prev_asg_id := 0;
1456: g_size := 0;
1457:
1458: end pay_za_irp5_archive_pkg;