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 638: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

634: --------------------------------------------------------------------+
635:
636: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
637: IS
638: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
639: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
640: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
641: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

635:
636: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
637: IS
638: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
639: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
640: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
641: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

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

636: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
637: IS
638: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
639: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
640: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
641: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

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

637: IS
638: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
639: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
640: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
641: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

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

638: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
639: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
640: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
641: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

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

639: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
640: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
641: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

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

640: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */
641: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

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

641: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

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

642: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

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

643: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
651: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

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

644: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
651: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
652: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

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

645: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
651: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
652: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
653: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold

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

646: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
651: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
652: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
653: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
654: FROM pay_payroll_actions ppa

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

647: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
651: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
652: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
653: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
654: FROM pay_payroll_actions ppa
655: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

648: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
651: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
652: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
653: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
654: FROM pay_payroll_actions ppa
655: WHERE ppa.payroll_action_id = c_payroll_action_id;
656:

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

649: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
651: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
652: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
653: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
654: FROM pay_payroll_actions ppa
655: WHERE ppa.payroll_action_id = c_payroll_action_id;
656:
657:

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

928: --------------------------------------------------------------------+
929:
930: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
931: IS
932: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
933: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
934: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
935: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

929:
930: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
931: IS
932: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
933: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
934: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
935: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

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

930: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
931: IS
932: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
933: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
934: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
935: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

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

931: IS
932: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
933: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
934: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
935: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

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

932: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
933: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
934: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
935: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

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

933: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
934: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
935: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

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

934: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
935: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

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

935: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

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

936: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

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

937: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
945: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

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

938: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
945: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
946: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

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

939: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
945: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
946: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
947: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold

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

940: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
945: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
946: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
947: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
948: FROM pay_payroll_actions ppa

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

941: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
945: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
946: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
947: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
948: FROM pay_payroll_actions ppa
949: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

942: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
945: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
946: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
947: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
948: FROM pay_payroll_actions ppa
949: WHERE ppa.payroll_action_id = c_payroll_action_id;
950:

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

943: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
945: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
946: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
947: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
948: FROM pay_payroll_actions ppa
949: WHERE ppa.payroll_action_id = c_payroll_action_id;
950:
951:

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

1479: --------------------------------------------------------------------+
1480:
1481: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1482: IS
1483: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1484: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1485: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

1480:
1481: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1482: IS
1483: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1484: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1485: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,

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

1481: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1482: IS
1483: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1484: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1485: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,

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

1482: IS
1483: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1484: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1485: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,

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

1483: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1484: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1485: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,

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

1484: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1485: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,

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

1485: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,
1486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,

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

1486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,

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

1487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,

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

1488: pay_core_utils.get_parameter('TAX_STATE',legislative_parameters) Tax_state,
1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,

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

1489: pay_core_utils.get_parameter('REP_TYPE',legislative_parameters)report_type,
1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1497: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,

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

1490: pay_core_utils.get_parameter('REP_NAME',legislative_parameters)report_name,
1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1497: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1498: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,

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

1491: pay_core_utils.get_parameter('ACTT',legislative_parameters)act_override_threshold,
1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1497: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1498: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1499: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type

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

1492: pay_core_utils.get_parameter('VICT',legislative_parameters)vic_override_threshold,
1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1497: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1498: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1499: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1500: FROM pay_payroll_actions ppa

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

1493: pay_core_utils.get_parameter('NSWT',legislative_parameters)nsw_override_threshold,
1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1497: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1498: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1499: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1500: FROM pay_payroll_actions ppa
1501: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

1494: pay_core_utils.get_parameter('QLDT',legislative_parameters)qld_override_threshold,
1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1497: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1498: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1499: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1500: FROM pay_payroll_actions ppa
1501: WHERE ppa.payroll_action_id = c_payroll_action_id;
1502:

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

1495: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1497: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1498: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1499: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1500: FROM pay_payroll_actions ppa
1501: WHERE ppa.payroll_action_id = c_payroll_action_id;
1502:
1503:

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

1502:
1503:
1504:
1505: cursor csr_get_report_name(c_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE) is
1506: select pay_core_utils.get_parameter('REP_NAME',legislative_parameters)
1507: from pay_payroll_actions ppa
1508: where ppa.payroll_Action_id = c_payroll_Action_id;
1509:
1510: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS