APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_CUST_TRX_TYPES_ALL

Line 3134: FROM ra_cust_trx_types_all

3130: l_progress := 200;
3131: BEGIN
3132: SELECT SUBSEQUENT_TRX_TYPE_ID
3133: INTO l_inv_trx_type_id
3134: FROM ra_cust_trx_types_all
3135: WHERE CUST_TRX_TYPE_ID = l_pon_emd_fin_parameters.RA_TRX_TYPE_ID
3136: AND org_id = l_org_id;
3137: EXCEPTION
3138: WHEN No_Data_Found THEN

Line 4331: ra_cust_trx_types_all ctyp,

4327: INTO x_cash_receipt_id,
4328: x_receivable_app_id
4329: from ar_receivable_applications_all arp,
4330: ra_customer_trx_all rct,
4331: ra_cust_trx_types_all ctyp,
4332: ar_cash_receipts_all acr
4333: where arp.applied_customer_trx_id = p_parent_trx_id
4334: AND arp.org_id = p_org_id
4335: AND arp.status = 'APP'

Line 4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;

4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;

Line 4688: FROM ra_cust_trx_types_all

4684: l_gl_id_rev,
4685: l_start_date,
4686: l_end_date,
4687: l_deposit_trx_name
4688: FROM ra_cust_trx_types_all
4689: WHERE CUST_TRX_TYPE_ID = p_ra_trx_type_id
4690: AND org_id = p_org_id;
4691: EXCEPTION
4692: WHEN No_Data_Found THEN

Line 4730: FROM ra_cust_trx_types_all

4726: END IF;
4727: ELSIF (p_transaction_type_code = G_EMD_REFUND) THEN
4728: SELECT CREDIT_MEMO_TYPE_ID
4729: INTO l_credit_memo_type_id
4730: FROM ra_cust_trx_types_all
4731: WHERE CUST_TRX_TYPE_ID = p_ra_trx_type_id
4732: AND org_id = p_org_id;
4733: print_log('l_credit_memo_type_id:'||l_credit_memo_type_id);
4734: IF (l_credit_memo_type_id IS NULL) THEN

Line 4768: FROM ra_cust_trx_types_all

4764: l_gl_id_rev,
4765: l_start_date,
4766: l_end_date,
4767: l_cm_trx_name
4768: FROM ra_cust_trx_types_all
4769: WHERE CUST_TRX_TYPE_ID = l_credit_memo_type_id
4770: AND org_id = p_org_id;
4771: print_log('l_start_date:'||l_start_date||' l_end_date:'||l_end_date);
4772: IF NOT((Trunc(SYSDATE) >= l_start_date) AND

Line 4803: FROM ra_cust_trx_types_all

4799: END IF;
4800: ELSIF (p_transaction_type_code = G_EMD_FORFEIT) THEN
4801: SELECT SUBSEQUENT_TRX_TYPE_ID
4802: INTO l_subsequent_trx_type_id
4803: FROM ra_cust_trx_types_all
4804: WHERE CUST_TRX_TYPE_ID = p_ra_trx_type_id
4805: AND org_id = p_org_id;
4806:
4807: IF (l_subsequent_trx_type_id IS NULL) THEN

Line 4841: FROM ra_cust_trx_types_all

4837: l_gl_id_rev,
4838: l_start_date,
4839: l_end_date,
4840: l_invoice_trx_name
4841: FROM ra_cust_trx_types_all
4842: WHERE CUST_TRX_TYPE_ID = l_subsequent_trx_type_id
4843: AND org_id = p_org_id;
4844:
4845: IF NOT((Trunc(SYSDATE) >= l_start_date) AND

Line 5633: FROM ra_cust_trx_types_all

5629:
5630: BEGIN
5631: SELECT NAME
5632: INTO l_cust_trx_name
5633: FROM ra_cust_trx_types_all
5634: WHERE CUST_TRX_TYPE_ID = p_in_rec.trx_type_id
5635: AND org_id = p_in_rec.org_id;
5636: EXCEPTION
5637: WHEN OTHERS THEN