DBA Data[Home] [Help]

APPS.INV_SHORTCHECKEXEC_PVT dependencies on MTL_PARAMETERS

Line 567: FROM mtl_parameters

563: AND organization_id = p_organization_id;
564: --
565: CURSOR L_Org_crs IS
566: SELECT organization_code
567: FROM mtl_parameters
568: WHERE organization_id = p_organization_id;
569: --
570: CURSOR L_ShortParam_csr ( p_organization_id IN NUMBER ) IS
571: SELECT DECODE(check_wip_flag,1,wip_notif_comp_planner_flag,2)

Line 1037: FROM mtl_parameters mp

1033: - NVL(bcd1.seq_num, bcd1.next_seq_num)
1034: + 1
1035: )
1036: INTO l_num_days
1037: FROM mtl_parameters mp
1038: , bom_calendar_dates bcd1
1039: , bom_calendar_dates bcd2
1040: WHERE mp.organization_id = p_organization_id
1041: AND bcd1.calendar_code = mp.calendar_code