APPS.CN_COLLECTION_AIA_PUB dependencies on CN_NOT_TRX

Line 95: FROM cn_not_trx

91:
92: CURSOR check_not_trx(l_trans_seq_num number,p_org_id number)
93: IS
94: SELECT 1 FLAG
95: FROM cn_not_trx
96: WHERE source_trx_line_id = l_trans_seq_num --*** Line.Primary_Key
97: AND event_id = -1020
98: AND org_id = p_org_id;
99:

Line 728: 'CN_COLLECTION_AIA_PUB.loadrow_om api: l_update_check(in table cn_not_trx): ' || l_update_check

724: END LOOP;
725:
726: debugmsg
727: (
728: 'CN_COLLECTION_AIA_PUB.loadrow_om api: l_update_check(in table cn_not_trx): ' || l_update_check
729: )
730: ;
731: -- Since this order number has not been collected. so l_update_check = 'Y'
732: IF

Line 1015: FROM cn_not_trx

1011:
1012: CURSOR check_not_trx(l_trans_seq_num number,p_org_id number)
1013: IS
1014: SELECT 1 FLAG
1015: FROM cn_not_trx
1016: WHERE source_trx_line_id = l_trans_seq_num --*** Line.Primary_Key
1017: AND event_id = -1020
1018: AND org_id = p_org_id;
1019:

Line 1644: 'CN_COLLECTION_AIA_PUB.loadrow api: l_update_check(in table cn_not_trx): ' || l_update_check

1640: END LOOP;
1641:
1642: debugmsg
1643: (
1644: 'CN_COLLECTION_AIA_PUB.loadrow api: l_update_check(in table cn_not_trx): ' || l_update_check
1645: )
1646: ;
1647: -- Since this invoice number has not been collected. so l_update_check = 'Y'
1648: IF