DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on ORG_ACCT_PERIODS

Line 491: FROM ORG_ACCT_PERIODS

487:
488: CURSOR get_min_period( c_organization_id NUMBER )
489: IS
490: SELECT period_start_date
491: FROM ORG_ACCT_PERIODS
492: WHERE open_flag = 'Y'
493: AND organization_id = c_organization_id
494: ORDER BY period_start_date;
495:

Line 499: FROM ORG_ACCT_PERIODS

495:
496: CURSOR get_max_period( c_organization_id NUMBER )
497: IS
498: SELECT schedule_close_date
499: FROM ORG_ACCT_PERIODS
500: WHERE open_flag = 'Y'
501: AND organization_id = c_organization_id
502: ORDER BY schedule_close_date DESC;
503: