DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on ORG_ACCT_PERIODS

Line 36: FROM org_acct_periods

32: /* Commented for bug 9691823 to have same logic same as that of BaseTransaction
33:
34: SELECT acct_period_id
35: INTO x_acct_period_id
36: FROM org_acct_periods
37: WHERE period_close_date IS NULL
38: AND organization_id = p_organization_id
39: AND TRUNC(schedule_close_date) >=
40: TRUNC(NVL(p_transaction_date,sysdate))

Line 48: FROM org_acct_periods

44:
45: /* Added following statement for bug 9691823 */
46: SELECT acct_period_id
47: INTO x_acct_period_id
48: FROM org_acct_periods
49: WHERE period_close_date IS NULL
50: AND organization_id = p_organization_id
51: AND (schedule_close_date + 1) >
52: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_transaction_date,SYSDATE),