DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_CMN_RG_BALANCES

Line 1058: FROM JAI_CMN_RG_BALANCES

1054:
1055: --2001/06/22 Anuradha Parthasarathy
1056: CURSOR REG_BALANCE_CUR(p_org_id IN NUMBER,p_loc_id IN NUMBER) IS
1057: SELECT NVL(rg23a_balance,0) rg23a_balance ,NVL(rg23c_balance,0) rg23c_balance,NVL(pla_balance,0) pla_balance
1058: FROM JAI_CMN_RG_BALANCES
1059: WHERE organization_id = p_org_id AND location_id = p_loc_id;
1060:
1061: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1062: SELECT register_code