APPS.CN_UPGRADE_UTL_PKG dependencies on CN_PERIOD_STATUSES_ALL

Line 12: FROM cn_period_statuses_all

8:
9: CURSOR l_start_date_csr IS
10:
11: SELECT start_date
12: FROM cn_period_statuses_all
13: WHERE period_id = p_period_id
14: AND ((org_id = p_org_id) OR (org_id IS NULL AND p_org_id IS NULL));
15:
16: BEGIN

Line 43: FROM cn_period_statuses_all

39:
40: CURSOR l_end_date_csr IS
41:
42: SELECT end_date
43: FROM cn_period_statuses_all
44: WHERE period_id = p_period_id
45: AND ((org_id = p_org_id) OR (org_id IS NULL AND p_org_id IS NULL));
46:
47: BEGIN

Line 502: FROM cn_period_statuses_all status

498: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
499: AND ( CLP.PRESERVE_CREDIT_OVERRIDE_FLAG IS NULL
500: OR CLP.ADJUST_STATUS IS NULL)
501: AND EXISTS ( SELECT NULL
502: FROM cn_period_statuses_all status
503: WHERE status.org_id = clp.org_id
504: AND clp.processed_date BETWEEN status.start_date AND status.end_date
505: AND status.period_status = 'O'
506: );

Line 629: FROM cn_period_statuses_all status

625: SET cha.adjust_status = NVL(cha.adjust_status,'NEW')
626: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
627: AND cha.adjust_status IS NULL
628: AND EXISTS (SELECT NULL
629: FROM cn_period_statuses_all status
630: WHERE status.org_id = cha.org_id
631: AND cha.processed_date BETWEEN status.start_date AND status.end_date
632: AND status.period_status = 'O'
633: );

Line 789: FROM CN_PERIOD_STATUSES_ALL psa

785: AND cl.status = 'CALC'
786: AND cl.commission_header_id = ch.commission_header_id)
787: WHERE srp.ROWID BETWEEN l_start_rowid AND l_end_rowid
788: AND EXISTS ( SELECT null
789: FROM CN_PERIOD_STATUSES_ALL psa
790: WHERE psa.period_status = 'O'
791: AND psa.period_id = srp.period_id
792: AND psa.org_id = srp.org_id);
793: