APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 46: Cursor C_Osp_Ret_days(cpn_organization_id jai_cmn_inventory_orgs.organization_id%type) is

42: WHERE osp_header_id = pr_new.batch_id and
43: issue_recpt_flag = 'R';
44: /*Commented by Brathod for Inv.Convergence, Cursor is not used anywhere in the code*/
45:
46: Cursor C_Osp_Ret_days(cpn_organization_id jai_cmn_inventory_orgs.organization_id%type) is
47: SELECT MAX(NVL(OSP_RETURN_DAYS,0))
48: from JAI_CMN_INVENTORY_ORGS --JAI_OPM_ORGANIZATIONS
49: WHERE organization_id = cpn_organization_id;
50:

Line 48: from JAI_CMN_INVENTORY_ORGS --JAI_OPM_ORGANIZATIONS

44: /*Commented by Brathod for Inv.Convergence, Cursor is not used anywhere in the code*/
45:
46: Cursor C_Osp_Ret_days(cpn_organization_id jai_cmn_inventory_orgs.organization_id%type) is
47: SELECT MAX(NVL(OSP_RETURN_DAYS,0))
48: from JAI_CMN_INVENTORY_ORGS --JAI_OPM_ORGANIZATIONS
49: WHERE organization_id = cpn_organization_id;
50:
51: l_updated_by NUMBER;
52: l_reg_sel VARCHAR2(20);