APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on JAI_AP_TDS_THHOLD_GRPS

Line 742: -- group_id in existing system (by jai_ap_tds_thhold_grps table)

738: AND jl.lookup_type = G_JAI_INDIA_TAX_REGIMES
739: AND jl.lookup_code = pv_tax_regime
740: ;
741:
742: -- group_id in existing system (by jai_ap_tds_thhold_grps table)
743: CURSOR c_transition_count(pn_threshold_grp_id NUMBER) IS
744: SELECT COUNT(jatr.invoice_id) cnt_exists
745: FROM jai_ap_tds_repository jatr
746: WHERE jatr.threshold_grp_id = pn_threshold_grp_id

Line 915: --Loop all group_id in existing system (by jai_ap_tds_thhold_grps table)

911: FETCH c_get_tax_regime_info INTO r_c_get_tax_regime_info;
912: CLOSE c_get_tax_regime_info;
913:
914:
915: --Loop all group_id in existing system (by jai_ap_tds_thhold_grps table)
916: For r_thhold_grp_rec IN (SELECT DISTINCT jattg.threshold_grp_id
917: FROM jai_ap_tds_thhold_grps jattg
918: )
919: LOOP

Line 917: FROM jai_ap_tds_thhold_grps jattg

913:
914:
915: --Loop all group_id in existing system (by jai_ap_tds_thhold_grps table)
916: For r_thhold_grp_rec IN (SELECT DISTINCT jattg.threshold_grp_id
917: FROM jai_ap_tds_thhold_grps jattg
918: )
919: LOOP
920:
921: --Step 1. Pick all TDS invoices base on jai_ap_tds_thhold_trxs table.