APPS.AR_RECEIPT_API_PUB dependencies on AR_DISTRIBUTIONS

Line 8938: l_tax_account_id ar_distributions.code_combination_id%TYPE;

8934: l_val_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
8935: l_dflex_val_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
8936: l_creation_method_code ar_receipt_classes.creation_method_code%TYPE;
8937: /* Bug fix 2300268 */
8938: l_tax_account_id ar_distributions.code_combination_id%TYPE;
8939: /* Bug fix 2742388 */
8940: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
8941: l_org_return_status VARCHAR2(1);
8942: l_org_id NUMBER;

Line 11167: INSERT INTO ar_distributions (

11163:
11164: Reversing existing distribution when receipt was remitted
11165: */
11166: FORALL i in l_crh_upd.cash_receipt_history_id.first..l_crh_upd.cash_receipt_history_id.last
11167: INSERT INTO ar_distributions (
11168: line_id,
11169: source_id,
11170: source_table,
11171: source_type,

Line 11213: select ar_distributions_s.nextval,

11209: activity_bucket,
11210: ref_dist_ccid,
11211: ref_mf_dist_flag
11212: )
11213: select ar_distributions_s.nextval,
11214: l_crh_upd.reversal_Cash_receipt_hist_id(i),
11215: 'CRH',
11216: ard.source_type,
11217: ard.source_type_secondary,

Line 11257: FROM ar_distributions ard,

11253: ard.ref_account_class,
11254: ard.activity_bucket,
11255: ard.ref_dist_ccid,
11256: ard.ref_mf_dist_flag
11257: FROM ar_distributions ard,
11258: ar_Cash_receipt_history crh
11259: WHERE ard.source_id=crh.cash_receipt_history_id
11260: and ard.source_table = 'CRH'
11261: and cash_receipt_history_id=l_crh_upd.cash_receipt_history_id(i)