DBA Data[Home] [Help]

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on ORG_ACCT_PERIODS

Line 287: org_acct_periods f

283: IS
284: SELECT
285: f.acct_period_id
286: FROM
287: org_acct_periods f
288: WHERE f.organization_id = p_org_id
289: AND f.period_start_date <= c_rpt_from_date
290: AND f.schedule_close_date >= c_rpt_from_date;
291:

Line 298: org_acct_periods t

294: IS
295: SELECT
296: t.acct_period_id
297: FROM
298: org_acct_periods t
299: WHERE t.organization_id = p_org_id
300: AND t.period_start_date <= c_rpt_to_date
301: AND t.schedule_close_date >= c_rpt_to_date;
302:

Line 388: org_acct_periods f

384: IS
385: SELECT
386: f.acct_period_id
387: FROM
388: org_acct_periods f
389: WHERE f.organization_id = p_org_id
390: AND f.period_start_date <= c_rpt_from_date
391: AND f.schedule_close_date >= c_rpt_from_date
392: AND F.Open_Flag = 'N'

Line 401: org_acct_periods t

397: IS
398: SELECT
399: t.acct_period_id
400: FROM
401: org_acct_periods t
402: WHERE t.organization_id = p_org_id
403: AND t.period_start_date <= c_rpt_to_date
404: AND t.schedule_close_date >= c_rpt_to_date
405: AND T.Open_Flag = 'N'