DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on ORG_ACCT_PERIODS

Line 465: FROM ORG_ACCT_PERIODS

461:
462: CURSOR get_min_period( c_organization_id NUMBER )
463: IS
464: SELECT period_start_date
465: FROM ORG_ACCT_PERIODS
466: WHERE open_flag = 'Y'
467: AND organization_id = c_organization_id
468: ORDER BY period_start_date;
469:

Line 473: FROM ORG_ACCT_PERIODS

469:
470: CURSOR get_max_period( c_organization_id NUMBER )
471: IS
472: SELECT schedule_close_date
473: FROM ORG_ACCT_PERIODS
474: WHERE open_flag = 'Y'
475: AND organization_id = c_organization_id
476: ORDER BY schedule_close_date DESC;
477: