DBA Data[Home] [Help]

APPS.CN_SRP_PERIODS_PVT dependencies on CN_REPOSITORIES_ALL

Line 459: from cn_period_statuses_all p, cn_repositories_all r

455:
456:
457: CURSOR get_summ_pds(c_credit_type_id cn_srp_periods.credit_type_id%TYPE) IS
458: select p.period_id, p.start_date, p.end_date
459: from cn_period_statuses_all p, cn_repositories_all r
460: where p.period_id >= l_min_period_id
461: and r.period_type_id = p.period_type_id
462: and r.period_set_id = p.period_set_id
463: AND p.org_id = l_org_id

Line 475: from cn_period_statuses_all p, cn_repositories_all r

471: order by 1;
472:
473: CURSOR get_carry_pds(c_credit_type_id cn_srp_periods.credit_type_id%TYPE) IS
474: select p.period_id, p.start_date, p.end_date
475: from cn_period_statuses_all p, cn_repositories_all r
476: where p.period_id >= l_min_period_id
477: and r.period_type_id = p.period_type_id
478: and r.period_set_id = p.period_set_id
479: AND p.org_id = l_org_id