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.PAY_AU_PAYTAX_PKG dependencies on PAY_CORE_UTILS

Line 340: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

336: --------------------------------------------------------------------+
337:
338: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
339: IS
340: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
341: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

Line 341: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

337:
338: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
339: IS
340: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
341: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

Line 342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /4709766 /

338: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
339: IS
340: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
341: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

Line 343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,

339: IS
340: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
341: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

Line 344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

340: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
341: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

Line 345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

341: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

Line 346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

Line 347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

343: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

Line 348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

344: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

Line 349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

345: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

Line 350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

346: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
354: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

Line 351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

347: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
354: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
355: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold

Line 352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

348: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
354: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
355: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
356: FROM pay_payroll_actions ppa

Line 353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

349: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
354: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
355: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
356: FROM pay_payroll_actions ppa
357: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 354: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

350: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
354: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
355: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
356: FROM pay_payroll_actions ppa
357: WHERE ppa.payroll_action_id = c_payroll_action_id;
358:

Line 355: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold

351: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
354: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
355: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
356: FROM pay_payroll_actions ppa
357: WHERE ppa.payroll_action_id = c_payroll_action_id;
358:
359:

Line 631: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

627: --------------------------------------------------------------------+
628:
629: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
630: IS
631: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
632: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

Line 632: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

628:
629: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
630: IS
631: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
632: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

Line 633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,

629: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
630: IS
631: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
632: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

Line 634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,

630: IS
631: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
632: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

Line 635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

631: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
632: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

Line 636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

632: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

Line 637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

Line 638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

634: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

Line 639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

635: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

Line 640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

636: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

Line 641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

637: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
645: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

Line 642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

638: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
645: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
646: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold

Line 643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

639: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
645: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
646: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
647: FROM pay_payroll_actions ppa

Line 644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

640: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
645: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
646: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
647: FROM pay_payroll_actions ppa
648: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 645: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

641: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
645: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
646: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
647: FROM pay_payroll_actions ppa
648: WHERE ppa.payroll_action_id = c_payroll_action_id;
649:

Line 646: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold

642: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
645: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
646: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
647: FROM pay_payroll_actions ppa
648: WHERE ppa.payroll_action_id = c_payroll_action_id;
649:
650:

Line 1148: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

1144: --------------------------------------------------------------------+
1145:
1146: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1147: IS
1148: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1149: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

Line 1149: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

1145:
1146: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1147: IS
1148: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1149: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

Line 1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,

1146: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1147: IS
1148: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1149: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

Line 1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,

1147: IS
1148: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1149: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

Line 1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

1148: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1149: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

Line 1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

1149: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

Line 1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

Line 1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

1151: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

Line 1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

1152: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

Line 1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

1153: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

Line 1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

1154: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

Line 1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

1155: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1163: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,

Line 1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

1156: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1163: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1164: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type

Line 1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

1157: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1163: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1164: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1165: FROM pay_payroll_actions ppa

Line 1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

1158: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1163: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1164: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1165: FROM pay_payroll_actions ppa
1166: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 1163: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,

1159: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1163: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1164: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1165: FROM pay_payroll_actions ppa
1166: WHERE ppa.payroll_action_id = c_payroll_action_id;
1167:

Line 1164: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type

1160: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1163: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1164: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1165: FROM pay_payroll_actions ppa
1166: WHERE ppa.payroll_action_id = c_payroll_action_id;
1167:
1168:

Line 1171: select pay_core_utils.get_parameter('REP_NAME',legislative_parameters)

1167:
1168:
1169:
1170: cursor csr_get_report_name(c_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE) is
1171: select pay_core_utils.get_parameter('REP_NAME',legislative_parameters)
1172: from pay_payroll_actions ppa
1173: where ppa.payroll_Action_id = c_payroll_Action_id;
1174:
1175: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS