APPS.ARP_RECEIPTS_MAIN dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 57: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,

53: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
54: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
55: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
56: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
57: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
58: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
59: p_vat_rec OUT NOCOPY ar_vat_tax%ROWTYPE ,
60: p_curr_rec OUT NOCOPY ae_curr_rec_type ,
61: p_rule_rec OUT NOCOPY ae_rule_rec_type );

Line 83: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,

79: p_app_rec IN ar_receivable_applications%ROWTYPE ,
80: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
81: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
82: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
83: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
84: p_miscel_rec IN g_ae_miscel_rec_type ,
85: p_rule_rec IN ae_rule_rec_type ,
86: --{
87: p_from_llca_call IN VARCHAR2,

Line 1289: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,

1285: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
1286: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
1287: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1288: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1289: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
1290: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
1291: p_vat_rec OUT NOCOPY ar_vat_tax%ROWTYPE ,
1292: p_curr_rec OUT NOCOPY ae_curr_rec_type ,
1293: p_rule_rec OUT NOCOPY ae_rule_rec_type) IS

Line 1466: ra_cust_trx_line_gl_dist ctlgdcm

1462: ar_cash_receipts cr ,
1463: ar_receipt_method_accounts rma ,
1464: ra_customer_trx ctinv ,
1465: ra_customer_trx ctcm ,
1466: ra_cust_trx_line_gl_dist ctlgdcm
1467: where ra.receivable_application_id = g_ae_doc_rec.source_id
1468: and ra.cash_receipt_id = cr.cash_receipt_id (+) --CR UNID, ACC, UNAPP exchange rate Information
1469: and cr.remit_bank_acct_use_id = rma.remit_bank_acct_use_id (+) --UNAPP ccid for receipt
1470: and cr.receipt_method_id = rma.receipt_method_id (+)

Line 1905: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;

1901: l_app_rec ar_receivable_applications%ROWTYPE ;
1902: l_cr_rec ar_cash_receipts%ROWTYPE ;
1903: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1904: l_cust_cm_rec ra_customer_trx%ROWTYPE ;
1905: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1906: l_vat_rec ar_vat_tax%ROWTYPE ;
1907: l_curr_rec ae_curr_rec_type ;
1908: l_rule_rec ae_rule_rec_type ;
1909: l_tmp_upg_method ra_customer_trx.upgrade_method%TYPE;

Line 2055: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,

2051: p_app_rec IN ar_receivable_applications%ROWTYPE ,
2052: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
2053: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
2054: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
2055: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
2056: p_miscel_rec IN g_ae_miscel_rec_type ,
2057: p_rule_rec IN ae_rule_rec_type ,
2058: --{HYUDETUPT
2059: p_from_llca_call IN VARCHAR2,

Line 2432: from ra_cust_trx_line_gl_dist gld

2428: IF p_cust_inv_rec.upgrade_method = 'R12_MERGE' THEN
2429: BEGIN
2430: select 'Y'
2431: into l_def_tax_flag
2432: from ra_cust_trx_line_gl_dist gld
2433: where gld.account_class = 'TAX'
2434: and gld.customer_trx_id = p_cust_inv_rec.customer_trx_id
2435: and gld.collected_tax_ccid IS NOT NULL
2436: and rownum = 1;

Line 2515: from ra_cust_trx_line_gl_dist

2511: 'TAX', 'APP_TAX',
2512: 'FREIGHT', 'APP_FRT',
2513: 'CHARGES', 'APP_CHRG',
2514: NULL) activity_bucket
2515: from ra_cust_trx_line_gl_dist
2516: where customer_trx_id = p_cust_inv_rec.customer_trx_id
2517: and customer_trx_line_id is not null
2518: and account_set_flag = 'N') Loop
2519:

Line 2568: from ra_cust_trx_line_gl_dist

2564: 'TAX', 'APP_TAX',
2565: 'FREIGHT', 'APP_FRT',
2566: 'CHARGES', 'APP_CHRG',
2567: NULL) activity_bucket
2568: from ra_cust_trx_line_gl_dist
2569: where customer_trx_id = p_cust_cm_rec.customer_trx_id
2570: and customer_trx_line_id is not null
2571: and account_set_flag = 'N') Loop
2572:

Line 2835: from ra_cust_trx_line_gl_dist gld

2831: IF p_cust_cm_rec.upgrade_method = 'R12_MERGE' THEN
2832: BEGIN
2833: select 'Y'
2834: into l_def_tax_flag
2835: from ra_cust_trx_line_gl_dist gld
2836: where gld.account_class = 'TAX'
2837: and gld.customer_trx_id = p_cust_cm_rec.customer_trx_id
2838: and gld.collected_tax_ccid IS NOT NULL
2839: and rownum = 1;