DBA Data[Home] [Help]

APPS.PQP_INI_BAL dependencies on PQP_UTILITIES

Line 688: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE

684: car_ni_amt := car_ni_amt + current_car_ni_amt;
685: car_tax_amt := car_tax_amt + current_car_tax_amt;
686: car_prc_amt := car_prc_amt + current_car_prc_amt;
687: car_tot_miles := car_tot_miles + current_car_tot_miles;
688: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE
689: (P_BUSINESS_GROUP_ID => NULL
690: ,P_EFFECTIVE_DATE => sysdate
691: ,P_TABLE_NAME => 'PQP_NIC_MILEAGE_RATES'
692: ,P_COLUMN_NAME => '9999'

Line 696: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE

692: ,P_COLUMN_NAME => '9999'
693: ,P_ROW_NAME => '99999'
694: ,P_VALUE => ni_rate
695: ,P_ERROR_MSG => err_msg );
696: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE
697: (P_BUSINESS_GROUP_ID => NULL
698: ,P_EFFECTIVE_DATE => sysdate
699: ,P_TABLE_NAME => 'PQP_INLAND_REV_AUTH_MILEAGE_RATES'
700: ,P_COLUMN_NAME => '9999'

Line 704: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE

700: ,P_COLUMN_NAME => '9999'
701: ,P_ROW_NAME => '10000'
702: ,P_VALUE => low_band_iram_rate
703: ,P_ERROR_MSG => err_msg );
704: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE
705: (P_BUSINESS_GROUP_ID => NULL
706: ,P_EFFECTIVE_DATE => sysdate
707: ,P_TABLE_NAME => 'PQP_INLAND_REV_AUTH_MILEAGE_RATES'
708: ,P_COLUMN_NAME => '9999'

Line 747: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE

743: mc_ni_amt := mc_ni_amt + current_mc_ni_amt;
744: mc_tax_amt := mc_tax_amt + current_mc_tax_amt;
745: mc_prc_amt := mc_prc_amt + current_mc_prc_amt;
746: mc_tot_miles := mc_tot_miles + current_mc_tot_miles;
747: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE
748: (P_BUSINESS_GROUP_ID => NULL
749: ,P_EFFECTIVE_DATE => sysdate
750: ,P_TABLE_NAME => 'PQP_NIC_MILEAGE_RATES'
751: ,P_COLUMN_NAME => '9999'

Line 755: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE

751: ,P_COLUMN_NAME => '9999'
752: ,P_ROW_NAME => 'MOTOR CYCLE'
753: ,P_VALUE => ni_rate
754: ,P_ERROR_MSG => err_msg );
755: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE
756: (P_BUSINESS_GROUP_ID => NULL
757: ,P_EFFECTIVE_DATE => sysdate
758: ,P_TABLE_NAME => 'PQP_INLAND_REV_AUTH_MILEAGE_RATES'
759: ,P_COLUMN_NAME => '9999'

Line 795: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE

791: pc_ni_amt := pc_ni_amt + current_pc_ni_amt;
792: pc_tax_amt := pc_tax_amt + current_pc_tax_amt;
793: pc_prc_amt := pc_prc_amt + current_pc_prc_amt;
794: pc_tot_miles := pc_tot_miles + current_pc_tot_miles;
795: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE
796: (P_BUSINESS_GROUP_ID => NULL
797: ,P_EFFECTIVE_DATE => sysdate
798: ,P_TABLE_NAME => 'PQP_NIC_MILEAGE_RATES'
799: ,P_COLUMN_NAME => '9999'

Line 803: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE

799: ,P_COLUMN_NAME => '9999'
800: ,P_ROW_NAME => 'PEDAL CYCLE'
801: ,P_VALUE => ni_rate
802: ,P_ERROR_MSG => err_msg );
803: ret := PQP_UTILITIES.PQP_GB_GET_TABLE_VALUE
804: (P_BUSINESS_GROUP_ID => NULL
805: ,P_EFFECTIVE_DATE => sysdate
806: ,P_TABLE_NAME => 'PQP_INLAND_REV_AUTH_MILEAGE_RATES'
807: ,P_COLUMN_NAME => '9999'