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.PAYUSUNB_PKG dependencies on PAY_US_PAYROLL_UTILS

Line 480: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_STATE');

476:
477: /************************* 3005756 start ********************************/
478: -- Fetch the balance validity flags into the global variables for use in
479: -- prc_process_data
480: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_STATE');
481: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_COUNTY');
482: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_CITY');
483: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_SCHOOL');
484: /************************* 3005756 end *********************************/

Line 481: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_COUNTY');

477: /************************* 3005756 start ********************************/
478: -- Fetch the balance validity flags into the global variables for use in
479: -- prc_process_data
480: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_STATE');
481: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_COUNTY');
482: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_CITY');
483: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_SCHOOL');
484: /************************* 3005756 end *********************************/
485:

Line 482: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_CITY');

478: -- Fetch the balance validity flags into the global variables for use in
479: -- prc_process_data
480: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_STATE');
481: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_COUNTY');
482: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_CITY');
483: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_SCHOOL');
484: /************************* 3005756 end *********************************/
485:
486: l_range_person := pay_ac_utility.range_person_on(

Line 483: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_SCHOOL');

479: -- prc_process_data
480: G_state_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_STATE');
481: G_county_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_COUNTY');
482: G_city_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_CITY');
483: G_school_flag := pay_us_payroll_utils.check_balance_status(L_start_date,L_gre_id,'UNB_SCHOOL');
484: /************************* 3005756 end *********************************/
485:
486: l_range_person := pay_ac_utility.range_person_on(
487: p_report_type => 'PAYUSUNB'

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

1196: L_sit_exists pay_us_state_tax_info_f.sit_exists%TYPE;
1197:
1198: BEGIN
1199:
1200: IF pay_us_payroll_utils.ltr_state_tax_info.count < 1 THEN
1201: pay_us_payroll_utils.populate_jit_information ( p_effective_date => IN_as_of_date
1202: ,p_get_state => 'Y' );
1203: END IF;
1204:

Line 1201: pay_us_payroll_utils.populate_jit_information ( p_effective_date => IN_as_of_date

1197:
1198: BEGIN
1199:
1200: IF pay_us_payroll_utils.ltr_state_tax_info.count < 1 THEN
1201: pay_us_payroll_utils.populate_jit_information ( p_effective_date => IN_as_of_date
1202: ,p_get_state => 'Y' );
1203: END IF;
1204:
1205: IF pay_us_payroll_utils.ltr_state_tax_info.exists(IN_state_code) THEN

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

1201: pay_us_payroll_utils.populate_jit_information ( p_effective_date => IN_as_of_date
1202: ,p_get_state => 'Y' );
1203: END IF;
1204:
1205: IF pay_us_payroll_utils.ltr_state_tax_info.exists(IN_state_code) THEN
1206: L_sit_exists := pay_us_payroll_utils.ltr_state_tax_info(IN_state_code).sit_exists ;
1207: END IF;
1208:
1209: /************************** 3005756 END ********************************************/

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

1202: ,p_get_state => 'Y' );
1203: END IF;
1204:
1205: IF pay_us_payroll_utils.ltr_state_tax_info.exists(IN_state_code) THEN
1206: L_sit_exists := pay_us_payroll_utils.ltr_state_tax_info(IN_state_code).sit_exists ;
1207: END IF;
1208:
1209: /************************** 3005756 END ********************************************/
1210:

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

3678:
3679: -- If the federal pl/sql table is empty populate it and then fetch the
3680: -- values into global variables
3681:
3682: IF pay_us_payroll_utils.ltr_fed_tax_info.count<1 THEN
3683: pay_us_payroll_utils.populate_jit_information(p_effective_date => L_as_of_date
3684: ,p_get_federal => 'Y' );
3685: END IF;
3686:

Line 3683: pay_us_payroll_utils.populate_jit_information(p_effective_date => L_as_of_date

3679: -- If the federal pl/sql table is empty populate it and then fetch the
3680: -- values into global variables
3681:
3682: IF pay_us_payroll_utils.ltr_fed_tax_info.count<1 THEN
3683: pay_us_payroll_utils.populate_jit_information(p_effective_date => L_as_of_date
3684: ,p_get_federal => 'Y' );
3685: END IF;
3686:
3687: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;

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

3683: pay_us_payroll_utils.populate_jit_information(p_effective_date => L_as_of_date
3684: ,p_get_federal => 'Y' );
3685: END IF;
3686:
3687: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
3688: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
3689: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
3690: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
3691: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;

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

3684: ,p_get_federal => 'Y' );
3685: END IF;
3686:
3687: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
3688: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
3689: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
3690: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
3691: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
3692: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;

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

3685: END IF;
3686:
3687: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
3688: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
3689: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
3690: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
3691: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
3692: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
3693:

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

3686:
3687: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
3688: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
3689: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
3690: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
3691: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
3692: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
3693:
3694: /****************************** 3005756 END ***************************************/

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

3687: G_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
3688: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
3689: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
3690: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
3691: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
3692: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
3693:
3694: /****************************** 3005756 END ***************************************/
3695:

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

3688: G_ss_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
3689: G_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
3690: G_ss_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
3691: G_medi_ee_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
3692: G_medi_er_rate := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
3693:
3694: /****************************** 3005756 END ***************************************/
3695:
3696: