DBA Data[Home] [Help]

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_REPOSITORIES_ALL

Line 542: FROM CN_REPOSITORIES_ALL CR

538: WHERE r1.end_date >= NVL(x_start_date, pa.start_date)
539: AND (R1.PERIOD_SET_ID, R1.PERIOD_TYPE_ID ) IN
540: (SELECT CR.PERIOD_SET_ID,
541: CR.PERIOD_TYPE_ID
542: FROM CN_REPOSITORIES_ALL CR
543: WHERE cr.org_id= r1.org_id
544: )
545: AND R1.PERIOD_STATUS IN ('O', 'F')
546: AND r1.org_id = pa.org_id

Line 654: FROM CN_REPOSITORIES_ALL CR

650: WHERE r1.end_date >= NVL(x_start_date, pa.start_date)
651: AND (R1.PERIOD_SET_ID, R1.PERIOD_TYPE_ID ) IN
652: (SELECT CR.PERIOD_SET_ID,
653: CR.PERIOD_TYPE_ID
654: FROM CN_REPOSITORIES_ALL CR
655: WHERE cr.org_id= r1.org_id
656: )
657: AND R1.PERIOD_STATUS IN ('O', 'F')
658: AND r1.org_id = pa.org_id

Line 771: FROM CN_REPOSITORIES_ALL CR

767: WHERE r1.end_date >= NVL(x_start_date, pa.start_date)
768: AND (R1.PERIOD_SET_ID, R1.PERIOD_TYPE_ID ) IN
769: (SELECT CR.PERIOD_SET_ID,
770: CR.PERIOD_TYPE_ID
771: FROM CN_REPOSITORIES_ALL CR
772: WHERE cr.org_id= r1.org_id
773: )
774: AND R1.PERIOD_STATUS IN ('O', 'F')
775: AND r1.org_id = pa.org_id