eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_REPOSITORIES

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

Line 975: FROM cn_repositories r,

971: BEGIN
972: -- get precision
973: SELECT c.extended_precision
974: INTO g_ext_precision
975: FROM cn_repositories r,
976: gl_sets_of_books b ,
977: fnd_currencies c ,
978: cn_srp_period_quotas spq
979: WHERE r.org_id = spq.org_id

Line 1553: FROM cn_repositories r,

1549: BEGIN
1550: -- get precision
1551: SELECT c.extended_precision
1552: INTO g_ext_precision
1553: FROM cn_repositories r,
1554: gl_sets_of_books b ,
1555: fnd_currencies c ,
1556: cn_srp_quota_assigns sqa
1557: WHERE r.org_id = sqa.org_id