APPS.AR_UPG_PSA_DIST_PKG dependencies on PSA_MF_ADJ_DIST_ALL

Line 23: FROM psa_mf_adj_dist_all

19: l_rows_processed number := 0;
20:
21: CURSOR c(p_start_rowid IN ROWID,p_end_rowid IN ROWID) IS
22: SELECT count(*)
23: FROM psa_mf_adj_dist_all
24: WHERE rowid >= p_start_rowid
25: AND rowid <= p_end_rowid;
26:
27: l_nb_row NUMBER;

Line 130: , 'PSA_MF_ADJ_DIST_ALL' -- SOURCE_TYPE_SECONDARY

126: , ard.THIRD_PARTY_SUB_ID
127: , ard.REVERSED_SOURCE_ID
128: , ard.TAX_CODE_ID
129: , ard.LOCATION_SEGMENT_ID
130: , 'PSA_MF_ADJ_DIST_ALL' -- SOURCE_TYPE_SECONDARY
131: , ard.TAX_GROUP_CODE_ID
132: , ard.REF_CUSTOMER_TRX_LINE_ID
133: , ard.REF_CUST_TRX_LINE_GL_DIST_ID
134: , ard.REF_ACCOUNT_CLASS

Line 149: AND EXISTS (SELECT NULL FROM psa_mf_adj_dist_all a

145: WHERE adj.rowid >= l_start_rowid
146: AND adj.rowid <= l_end_rowid
147: AND ard.source_table = 'ADJ'
148: AND ard.source_id = adj.adjustment_id
149: AND EXISTS (SELECT NULL FROM psa_mf_adj_dist_all a
150: WHERE a.adjustment_id = adj.adjustment_id);
151:
152: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;
153:

Line 250: , 'PSA_MF_ADJ_DIST_ALL' -- SOURCE_TYPE_SECONDARY

246: , NULL -- THIRD_PARTY_SUB_ID
247: , NULL -- REVERSED_SOURCE_ID
248: , NULL -- TAX_CODE_ID
249: , NULL -- LOCATION_SEGMENT_ID
250: , 'PSA_MF_ADJ_DIST_ALL' -- SOURCE_TYPE_SECONDARY
251: , NULL -- TAX_GROUP_CODE_ID
252: , ctlgd.customer_trx_line_id -- REF_CUSTOMER_TRX_LINE_ID
253: , psatd.cust_trx_line_gl_dist_id -- REF_CUST_TRX_LINE_GL_DIST_ID
254: , ctlgd.account_class -- REF_ACCOUNT_CLASS

Line 272: psa_mf_adj_dist_all psaadj,

268: , NULL -- REF_MF_DIST_FLAG
269: , NULL -- REF_DIST_CCID
270: FROM
271: ar_adjustments_all adj,
272: psa_mf_adj_dist_all psaadj,
273: (SELECT a.flag side,
274: b.adjustment_id adj_id,
275: b.customer_trx_id customer_trx_id,
276: b.type type