DBA Data[Home] [Help]

APPS.INV_CG_UPGRADE dependencies on ORG_ACCT_PERIODS

Line 1326: /*Bug3768349 --Changed the cursor acct_cursor from org_acct_periods_v to the table org_acct_periods.

1322: -- ** --------------------------------------------------------
1323: -- */
1324: -- */
1325:
1326: /*Bug3768349 --Changed the cursor acct_cursor from org_acct_periods_v to the table org_acct_periods.
1327: Also removed the condition 'or (rownum<2 and p_open_periods_only<>1)'*/
1328:
1329: cursor acct_cursor(
1330: l_organization_id number, p_open_periods_only number )

Line 1334: from org_acct_periods

1330: l_organization_id number, p_open_periods_only number )
1331: is
1332: select period_start_date,
1333: schedule_close_date
1334: from org_acct_periods
1335: where (organization_id = l_organization_id
1336: and period_start_date <= sysdate and period_close_date is null
1337: and p_open_periods_only = 1);
1338: