DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_CMN_RG_BALANCES

Line 1046: FROM JAI_CMN_RG_BALANCES

1042:
1043: --2001/06/22 Anuradha Parthasarathy
1044: CURSOR REG_BALANCE_CUR(p_org_id IN NUMBER,p_loc_id IN NUMBER) IS
1045: SELECT NVL(rg23a_balance,0) rg23a_balance ,NVL(rg23c_balance,0) rg23c_balance,NVL(pla_balance,0) pla_balance
1046: FROM JAI_CMN_RG_BALANCES
1047: WHERE organization_id = p_org_id AND location_id = p_loc_id;
1048:
1049: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1050: SELECT register_code