DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on ORG_ACCT_PERIODS

Line 1756: FROM org_acct_periods

1752: IF (chk_date = 1)
1753: THEN
1754: SELECT acct_period_id
1755: INTO acct_period_id
1756: FROM org_acct_periods
1757: WHERE period_close_date IS NULL
1758: AND organization_id = p_org_id
1759: AND NVL (p_trans_date, SYSDATE) BETWEEN period_start_date
1760: AND schedule_close_date

Line 1765: FROM org_acct_periods

1761: ORDER BY period_start_date DESC, schedule_close_date ASC;
1762: ELSE
1763: SELECT acct_period_id
1764: INTO acct_period_id
1765: FROM org_acct_periods
1766: WHERE period_close_date IS NULL
1767: AND organization_id = p_org_id
1768: AND TRUNC (schedule_close_date) >=
1769: TRUNC (NVL (p_trans_date, SYSDATE))