APPS.DDR_EMD_UTIL dependencies on DDR_R_ORG_BSNS_UNIT

Line 893: v_bsns_unit_id ddr_r_org_bsns_unit.org_bsns_unit_id%TYPE;

889: ,p_calc_npisales_excptn IN BOOLEAN
890: ,x_return_status OUT NOCOPY VARCHAR2
891: ,x_msg OUT NOCOPY VARCHAR2
892: ) IS
893: v_bsns_unit_id ddr_r_org_bsns_unit.org_bsns_unit_id%TYPE;
894: v_calc_ifpl_excptn VARCHAR(1):= NULL;
895: v_calc_oosim_excptn VARCHAR(1):= NULL;
896:
897: BEGIN

Line 902: FROM ddr_r_org_bsns_unit

898: IF p_bsns_unit_cd IS NOT NULL THEN --{
899: BEGIN
900: SELECT org_bsns_unit_id
901: INTO v_bsns_unit_id
902: FROM ddr_r_org_bsns_unit
903: WHERE org_cd = NVL(p_rtl_org_cd,org_cd)
904: AND bsns_unit_cd = p_bsns_unit_cd
905: --AND eff_to_dt IS NULL;
906: AND eff_to_dt = to_date('01012400','MMDDYYYY');