APPS.GMF_COPY_ITEM_COST dependencies on DUAL

Line 333: FROM dual ;

329: BEGIN
330: g_effid_copy := FND_PROFILE.VALUE('GMF_CPIC_EFF') ;
331: SELECT decode(g_effid_copy, 'Y', 'YES', 'N', 'NO', '')
332: INTO l_effid_copy
333: FROM dual ;
334: gmf_util.msg_log('GMF_CPIC_EFFID', l_effid_copy ) ; --niyadav
335:
336: EXCEPTION
337: WHEN OTHERS THEN

Line 730: l_sql_org := 'SELECT :pi_organization_id_to '||' FROM dual ' ;

726: IF (pi_organization_id_to IS NOT NULL) THEN
727:
728: l_sql_org := '' ;
729:
730: l_sql_org := 'SELECT :pi_organization_id_to '||' FROM dual ' ;
731:
732: ELSE
733:
734: -- 'All Warehouse' option selected

Line 775: l_sql_periods := 'SELECT :pi_period_id_to FROM dual ' ;

771: -- Build SQL to get target periods when From/To Periods are not null.
772:
773: IF (pi_period_id_to IS NOT NULL) THEN -- copy to one period.
774:
775: l_sql_periods := 'SELECT :pi_period_id_to FROM dual ' ;
776:
777: ELSE
778: l_sql_periods := '' ;
779: if(pi_organization_id_to is not null) then

Line 2111: l_sql_org_b := 'SELECT :pi_organization_id_to FROM dual ' ;

2107:
2108: IF (pi_organization_id_to IS NOT NULL) THEN -- copying to one organization
2109:
2110: l_sql_org_b := '' ;
2111: l_sql_org_b := 'SELECT :pi_organization_id_to FROM dual ' ;
2112:
2113: ELSE
2114:
2115: -- 'All organizations' option selected

Line 2154: l_sql_periods_b := 'SELECT :pi_period_id_to FROM dual ' ;

2150:
2151:
2152: -- Build SQL to get target periods when From/To Periods are not null.
2153: IF (pi_period_code_to IS NOT NULL) THEN -- copy to one period.
2154: l_sql_periods_b := 'SELECT :pi_period_id_to FROM dual ' ;
2155: ELSE
2156: l_sql_periods_b := '' ;
2157: if(pi_organization_id_to is not null) then
2158: l_sql_periods_b := 'SELECT ' ||