DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_PAYROLL_UTILS

Line 662: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_STATE');

658:
659: /************************* 3005756 start ********************************/
660: -- Fetch the balance validity flags into the global variables for use in
661: -- prc_process_data
662: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_STATE');
663: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_COUNTY');
664: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_CITY');
665: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_SCHOOL');
666: /************************* 3005756 end *********************************/

Line 663: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_COUNTY');

659: /************************* 3005756 start ********************************/
660: -- Fetch the balance validity flags into the global variables for use in
661: -- prc_process_data
662: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_STATE');
663: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_COUNTY');
664: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_CITY');
665: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_SCHOOL');
666: /************************* 3005756 end *********************************/
667:

Line 664: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_CITY');

660: -- Fetch the balance validity flags into the global variables for use in
661: -- prc_process_data
662: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_STATE');
663: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_COUNTY');
664: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_CITY');
665: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_SCHOOL');
666: /************************* 3005756 end *********************************/
667:
668: l_range_person := pay_ac_utility.range_person_on(

Line 665: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_SCHOOL');

661: -- prc_process_data
662: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_STATE');
663: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_COUNTY');
664: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_CITY');
665: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_business_id,'UNB_SCHOOL');
666: /************************* 3005756 end *********************************/
667:
668: l_range_person := pay_ac_utility.range_person_on(
669: p_report_type => 'PAYUSUNB'

Line 1685: IF pay_us_payroll_utils.ltr_state_tax_info.count < 1 THEN

1681: L_sit_exists pay_us_state_tax_info_f.sit_exists%TYPE;
1682:
1683: BEGIN
1684:
1685: IF pay_us_payroll_utils.ltr_state_tax_info.count < 1 THEN
1686: pay_us_payroll_utils.populate_jit_information ( p_effective_date => IN_as_of_date
1687: ,p_get_state => 'Y' );
1688: END IF;
1689:

Line 1686: pay_us_payroll_utils.populate_jit_information ( p_effective_date => IN_as_of_date

1682:
1683: BEGIN
1684:
1685: IF pay_us_payroll_utils.ltr_state_tax_info.count < 1 THEN
1686: pay_us_payroll_utils.populate_jit_information ( p_effective_date => IN_as_of_date
1687: ,p_get_state => 'Y' );
1688: END IF;
1689:
1690: IF pay_us_payroll_utils.ltr_state_tax_info.exists(IN_state_code) THEN

Line 1690: IF pay_us_payroll_utils.ltr_state_tax_info.exists(IN_state_code) THEN

1686: pay_us_payroll_utils.populate_jit_information ( p_effective_date => IN_as_of_date
1687: ,p_get_state => 'Y' );
1688: END IF;
1689:
1690: IF pay_us_payroll_utils.ltr_state_tax_info.exists(IN_state_code) THEN
1691: L_sit_exists := pay_us_payroll_utils.ltr_state_tax_info(IN_state_code).sit_exists ;
1692: END IF;
1693:
1694: /************************** 3005756 END ********************************************/

Line 1691: L_sit_exists := pay_us_payroll_utils.ltr_state_tax_info(IN_state_code).sit_exists ;

1687: ,p_get_state => 'Y' );
1688: END IF;
1689:
1690: IF pay_us_payroll_utils.ltr_state_tax_info.exists(IN_state_code) THEN
1691: L_sit_exists := pay_us_payroll_utils.ltr_state_tax_info(IN_state_code).sit_exists ;
1692: END IF;
1693:
1694: /************************** 3005756 END ********************************************/
1695:

Line 4375: IF pay_us_payroll_utils.ltr_fed_tax_info.count<1 THEN

4371:
4372: -- If the federal pl/sql table is empty populate it and then fetch the
4373: -- values into global variables
4374:
4375: IF pay_us_payroll_utils.ltr_fed_tax_info.count<1 THEN
4376: pay_us_payroll_utils.populate_jit_information(p_effective_date => L_as_of_date
4377: ,p_get_federal => 'Y' );
4378: END IF;
4379:

Line 4376: pay_us_payroll_utils.populate_jit_information(p_effective_date => L_as_of_date

4372: -- If the federal pl/sql table is empty populate it and then fetch the
4373: -- values into global variables
4374:
4375: IF pay_us_payroll_utils.ltr_fed_tax_info.count<1 THEN
4376: pay_us_payroll_utils.populate_jit_information(p_effective_date => L_as_of_date
4377: ,p_get_federal => 'Y' );
4378: END IF;
4379:
4380: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;

Line 4380: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;

4376: pay_us_payroll_utils.populate_jit_information(p_effective_date => L_as_of_date
4377: ,p_get_federal => 'Y' );
4378: END IF;
4379:
4380: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
4381: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
4382: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
4383: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
4384: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;

Line 4381: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;

4377: ,p_get_federal => 'Y' );
4378: END IF;
4379:
4380: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
4381: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
4382: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
4383: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
4384: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
4385: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;

Line 4382: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;

4378: END IF;
4379:
4380: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
4381: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
4382: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
4383: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
4384: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
4385: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
4386:

Line 4383: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;

4379:
4380: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
4381: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
4382: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
4383: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
4384: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
4385: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
4386:
4387: /****************************** 3005756 END ***************************************/

Line 4384: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;

4380: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
4381: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
4382: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
4383: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
4384: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
4385: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
4386:
4387: /****************************** 3005756 END ***************************************/
4388:

Line 4385: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;

4381: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
4382: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
4383: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
4384: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
4385: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
4386:
4387: /****************************** 3005756 END ***************************************/
4388:
4389: