APPS.ARP_DET_DIST_PKG dependencies on RA_AR_AMOUNTS_GT

Line 2348: SELECT /*+INDEX (b ra_ar_n1) INDEX(d RA_AR_AMOUNTS_GT_N1)*/

2344: p_customer_trx_id IN NUMBER,
2345: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
2346: IS
2347: CURSOR c_read_for_line IS
2348: SELECT /*+INDEX (b ra_ar_n1) INDEX(d RA_AR_AMOUNTS_GT_N1)*/
2349: b.group_id||'-'||b.line_type||'-'||
2350: b.ref_customer_trx_id || '-' ||
2351: b.ref_customer_trx_line_id groupe,
2352: -- ADJ AND APP

Line 2444: RA_AR_AMOUNTS_GT d

2440: b.FROM_CURRENCY ,
2441: -- Rowid
2442: b.rowid
2443: FROM RA_AR_GT b,
2444: RA_AR_AMOUNTS_GT d
2445: WHERE b.gt_id = p_gt_id
2446: AND b.ref_customer_trx_id = p_customer_trx_id
2447: AND b.gp_level = 'L'
2448: AND d.gt_id = b.gt_id

Line 3588: INSERT INTO RA_AR_AMOUNTS_GT (

3584:
3585: ---------------------------------
3586: -- Determine the bucket for group
3587: ---------------------------------
3588: INSERT INTO RA_AR_AMOUNTS_GT (
3589: gt_id
3590: ,gp_level
3591: ,base_rec_rowid
3592: ,ref_customer_trx_id

Line 4585: INSERT INTO RA_AR_AMOUNTS_GT (

4581: -- update_group_line(p_gt_id => p_gt_id,
4582: -- p_customer_trx_id => p_customer_trx_id);
4583:
4584: --replaced the update with an insert for better performance[Bug 6454022]
4585: INSERT INTO RA_AR_AMOUNTS_GT (
4586: gt_id ,
4587: gp_level,
4588: base_rec_rowid,
4589: ref_customer_trx_id ,

Line 4676: SELECT /*+INDEX(c ra_ar_n1) INDEX(b ra_ar_n1) INDEX(d RA_AR_AMOUNTS_GT_N1)*/

4672: buc_uned_chrg_alloc_acctd_amt
4673: )
4674:
4675:
4676: SELECT /*+INDEX(c ra_ar_n1) INDEX(b ra_ar_n1) INDEX(d RA_AR_AMOUNTS_GT_N1)*/
4677: c.gt_id
4678: ,b.gp_level
4679: ,b.rowid
4680: ,c.ref_customer_trx_id

Line 4965: RA_AR_AMOUNTS_GT d

4961: ,c.TL_UNED_CHRG_ALLOC_AMT
4962: ,c.TL_UNED_CHRG_ALLOC_ACCTD_AMT
4963: FROM RA_AR_GT b,
4964: RA_AR_GT c,
4965: RA_AR_AMOUNTS_GT d
4966: WHERE b.gt_id = p_gt_id
4967: -- AND b.se_gt_id = g_se_gt_id
4968: AND b.ref_customer_trx_id = p_customer_trx_id
4969: AND b.gp_level = 'L'

Line 8904: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE

8900:
8901: PROCEDURE insert_ra_ar_gt
8902: ( p_ra_ar_gt IN ra_ar_gt%ROWTYPE,
8903: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,
8904: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE
8905: )
8906: IS
8907: l_rows NUMBER;
8908: l_base_rowid ROWID;

Line 9194: INSERT INTO RA_AR_AMOUNTS_GT

9190: ,p_ra_ar_gt.SOB_TYPE
9191: ,p_ra_ar_gt.SOURCE_TABLE
9192: );
9193:
9194: INSERT INTO RA_AR_AMOUNTS_GT
9195: (
9196: gt_id
9197: ,gp_level
9198: ,base_rec_rowid

Line 9300: ,p_ra_ar_amounts_gt.base_pro_amt

9296: ,l_base_rowid
9297: ,p_ra_ar_gt.ref_customer_trx_id
9298: ,p_ra_ar_gt.ref_customer_trx_line_id
9299:
9300: ,p_ra_ar_amounts_gt.base_pro_amt
9301: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
9302: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
9303: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
9304: --

Line 9301: ,p_ra_ar_amounts_gt.base_pro_acctd_amt

9297: ,p_ra_ar_gt.ref_customer_trx_id
9298: ,p_ra_ar_gt.ref_customer_trx_line_id
9299:
9300: ,p_ra_ar_amounts_gt.base_pro_amt
9301: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
9302: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
9303: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
9304: --
9305: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT

Line 9302: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT

9298: ,p_ra_ar_gt.ref_customer_trx_line_id
9299:
9300: ,p_ra_ar_amounts_gt.base_pro_amt
9301: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
9302: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
9303: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
9304: --
9305: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
9306: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT

Line 9303: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT

9299:
9300: ,p_ra_ar_amounts_gt.base_pro_amt
9301: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
9302: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
9303: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
9304: --
9305: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
9306: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
9307: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT

Line 9305: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT

9301: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
9302: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
9303: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
9304: --
9305: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
9306: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
9307: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
9308: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
9309: --

Line 9306: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT

9302: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
9303: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
9304: --
9305: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
9306: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
9307: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
9308: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
9309: --
9310: ,p_ra_ar_amounts_gt.elmt_pro_amt

Line 9307: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT

9303: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
9304: --
9305: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
9306: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
9307: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
9308: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
9309: --
9310: ,p_ra_ar_amounts_gt.elmt_pro_amt
9311: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt

Line 9308: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT

9304: --
9305: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
9306: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
9307: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
9308: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
9309: --
9310: ,p_ra_ar_amounts_gt.elmt_pro_amt
9311: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
9312: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT

Line 9310: ,p_ra_ar_amounts_gt.elmt_pro_amt

9306: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
9307: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
9308: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
9309: --
9310: ,p_ra_ar_amounts_gt.elmt_pro_amt
9311: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
9312: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
9313: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
9314: --

Line 9311: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt

9307: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
9308: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
9309: --
9310: ,p_ra_ar_amounts_gt.elmt_pro_amt
9311: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
9312: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
9313: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
9314: --
9315: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT

Line 9312: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT

9308: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
9309: --
9310: ,p_ra_ar_amounts_gt.elmt_pro_amt
9311: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
9312: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
9313: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
9314: --
9315: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
9316: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT

Line 9313: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT

9309: --
9310: ,p_ra_ar_amounts_gt.elmt_pro_amt
9311: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
9312: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
9313: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
9314: --
9315: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
9316: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
9317: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT

Line 9315: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT

9311: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
9312: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
9313: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
9314: --
9315: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
9316: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
9317: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
9318: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
9319: --

Line 9316: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT

9312: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
9313: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
9314: --
9315: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
9316: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
9317: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
9318: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
9319: --
9320: ,p_ra_ar_amounts_gt.buc_alloc_amt

Line 9317: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT

9313: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
9314: --
9315: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
9316: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
9317: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
9318: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
9319: --
9320: ,p_ra_ar_amounts_gt.buc_alloc_amt
9321: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt

Line 9318: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT

9314: --
9315: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
9316: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
9317: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
9318: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
9319: --
9320: ,p_ra_ar_amounts_gt.buc_alloc_amt
9321: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
9322: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt

Line 9320: ,p_ra_ar_amounts_gt.buc_alloc_amt

9316: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
9317: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
9318: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
9319: --
9320: ,p_ra_ar_amounts_gt.buc_alloc_amt
9321: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
9322: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
9323: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
9324: --

Line 9321: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt

9317: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
9318: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
9319: --
9320: ,p_ra_ar_amounts_gt.buc_alloc_amt
9321: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
9322: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
9323: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
9324: --
9325: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt

Line 9322: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt

9318: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
9319: --
9320: ,p_ra_ar_amounts_gt.buc_alloc_amt
9321: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
9322: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
9323: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
9324: --
9325: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
9326: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt

Line 9323: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt

9319: --
9320: ,p_ra_ar_amounts_gt.buc_alloc_amt
9321: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
9322: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
9323: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
9324: --
9325: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
9326: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
9327: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt

Line 9325: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt

9321: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
9322: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
9323: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
9324: --
9325: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
9326: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
9327: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
9328: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
9329:

Line 9326: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt

9322: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
9323: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
9324: --
9325: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
9326: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
9327: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
9328: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
9329:
9330: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT

Line 9327: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt

9323: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
9324: --
9325: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
9326: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
9327: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
9328: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
9329:
9330: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
9331: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT

Line 9328: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt

9324: --
9325: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
9326: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
9327: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
9328: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
9329:
9330: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
9331: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
9332: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT

Line 9330: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT

9326: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
9327: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
9328: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
9329:
9330: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
9331: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
9332: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
9333: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
9334: --

Line 9331: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT

9327: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
9328: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
9329:
9330: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
9331: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
9332: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
9333: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
9334: --
9335: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT

Line 9332: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT

9328: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
9329:
9330: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
9331: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
9332: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
9333: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
9334: --
9335: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
9336: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT

Line 9333: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT

9329:
9330: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
9331: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
9332: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
9333: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
9334: --
9335: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
9336: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
9337: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT

Line 9335: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT

9331: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
9332: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
9333: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
9334: --
9335: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
9336: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
9337: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
9338: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
9339: --

Line 9336: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT

9332: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
9333: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
9334: --
9335: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
9336: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
9337: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
9338: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
9339: --
9340: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT

Line 9337: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT

9333: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
9334: --
9335: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
9336: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
9337: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
9338: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
9339: --
9340: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
9341: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT

Line 9338: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT

9334: --
9335: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
9336: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
9337: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
9338: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
9339: --
9340: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
9341: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
9342: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT

Line 9340: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT

9336: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
9337: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
9338: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
9339: --
9340: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
9341: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
9342: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
9343: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
9344: --

Line 9341: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT

9337: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
9338: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
9339: --
9340: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
9341: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
9342: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
9343: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
9344: --
9345: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT

Line 9342: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT

9338: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
9339: --
9340: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
9341: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
9342: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
9343: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
9344: --
9345: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
9346: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT

Line 9343: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT

9339: --
9340: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
9341: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
9342: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
9343: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
9344: --
9345: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
9346: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
9347: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT

Line 9345: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT

9341: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
9342: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
9343: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
9344: --
9345: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
9346: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
9347: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
9348: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
9349: --

Line 9346: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT

9342: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
9343: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
9344: --
9345: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
9346: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
9347: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
9348: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
9349: --
9350: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT

Line 9347: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT

9343: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
9344: --
9345: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
9346: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
9347: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
9348: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
9349: --
9350: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
9351: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT

Line 9348: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT

9344: --
9345: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
9346: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
9347: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
9348: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
9349: --
9350: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
9351: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
9352: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT

Line 9350: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT

9346: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
9347: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
9348: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
9349: --
9350: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
9351: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
9352: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
9353: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
9354: --

Line 9351: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT

9347: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
9348: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
9349: --
9350: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
9351: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
9352: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
9353: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
9354: --
9355: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT

Line 9352: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT

9348: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
9349: --
9350: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
9351: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
9352: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
9353: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
9354: --
9355: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
9356: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT

Line 9353: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT

9349: --
9350: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
9351: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
9352: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
9353: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
9354: --
9355: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
9356: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
9357: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT

Line 9355: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT

9351: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
9352: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
9353: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
9354: --
9355: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
9356: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
9357: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
9358: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
9359:

Line 9356: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT

9352: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
9353: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
9354: --
9355: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
9356: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
9357: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
9358: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
9359:
9360: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT

Line 9357: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT

9353: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
9354: --
9355: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
9356: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
9357: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
9358: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
9359:
9360: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
9361: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT

Line 9358: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT

9354: --
9355: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
9356: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
9357: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
9358: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
9359:
9360: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
9361: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
9362: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT

Line 9360: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT

9356: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
9357: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
9358: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
9359:
9360: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
9361: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
9362: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
9363: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
9364: --

Line 9361: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT

9357: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
9358: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
9359:
9360: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
9361: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
9362: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
9363: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
9364: --
9365: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT

Line 9362: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT

9358: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
9359:
9360: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
9361: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
9362: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
9363: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
9364: --
9365: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
9366: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT

Line 9363: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT

9359:
9360: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
9361: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
9362: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
9363: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
9364: --
9365: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
9366: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
9367: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT

Line 9365: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT

9361: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
9362: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
9363: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
9364: --
9365: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
9366: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
9367: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
9368: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
9369: --

Line 9366: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT

9362: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
9363: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
9364: --
9365: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
9366: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
9367: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
9368: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
9369: --
9370: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT

Line 9367: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT

9363: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
9364: --
9365: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
9366: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
9367: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
9368: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
9369: --
9370: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
9371: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT

Line 9368: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT

9364: --
9365: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
9366: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
9367: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
9368: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
9369: --
9370: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
9371: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
9372: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT

Line 9370: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT

9366: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
9367: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
9368: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
9369: --
9370: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
9371: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
9372: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
9373: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
9374: --

Line 9371: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT

9367: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
9368: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
9369: --
9370: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
9371: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
9372: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
9373: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
9374: --
9375: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT

Line 9372: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT

9368: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
9369: --
9370: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
9371: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
9372: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
9373: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
9374: --
9375: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
9376: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT

Line 9373: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT

9369: --
9370: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
9371: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
9372: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
9373: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
9374: --
9375: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
9376: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
9377: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT

Line 9375: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT

9371: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
9372: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
9373: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
9374: --
9375: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
9376: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
9377: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
9378: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
9379: --

Line 9376: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT

9372: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
9373: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
9374: --
9375: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
9376: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
9377: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
9378: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
9379: --
9380: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT

Line 9377: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT

9373: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
9374: --
9375: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
9376: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
9377: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
9378: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
9379: --
9380: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
9381: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT

Line 9378: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT

9374: --
9375: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
9376: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
9377: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
9378: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
9379: --
9380: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
9381: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
9382: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT

Line 9380: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT

9376: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
9377: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
9378: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
9379: --
9380: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
9381: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
9382: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
9383: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
9384: --

Line 9381: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT

9377: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
9378: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
9379: --
9380: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
9381: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
9382: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
9383: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
9384: --
9385: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT

Line 9382: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT

9378: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
9379: --
9380: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
9381: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
9382: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
9383: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
9384: --
9385: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
9386: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT

Line 9383: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT

9379: --
9380: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
9381: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
9382: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
9383: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
9384: --
9385: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
9386: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
9387: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT

Line 9385: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT

9381: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
9382: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
9383: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
9384: --
9385: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
9386: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
9387: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT
9388: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
9389: );

Line 9386: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT

9382: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
9383: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
9384: --
9385: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
9386: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
9387: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT
9388: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
9389: );
9390: l_rows := sql%rowcount;

Line 9387: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT

9383: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
9384: --
9385: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
9386: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
9387: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT
9388: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
9389: );
9390: l_rows := sql%rowcount;
9391: IF PG_DEBUG = 'Y' THEN

Line 9388: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT

9384: --
9385: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
9386: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
9387: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT
9388: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
9389: );
9390: l_rows := sql%rowcount;
9391: IF PG_DEBUG = 'Y' THEN
9392: localdebug(' rows inserted into AR_BASE_DIST_AMTS_GT = ' || l_rows);

Line 9474: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;

9470: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
9471: IS
9472: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9473: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
9474: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
9475: BEGIN
9476: --Rev line boundary
9477: IF NVL(p_adj_rec.line_adjusted,0) <> 0 AND
9478: NVL(p_sum_line_orig_amt,0) = 0 AND

Line 9528: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

9524: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9525: l_ra_ar_gt.activity_bucket := 'ADJ';
9526: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9527: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9528: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9529: );
9530: END IF;
9531:
9532: --Charge boundary is part of line boundary estimation because frt over revenue line

Line 9584: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

9580: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9581: l_ra_ar_gt.activity_bucket := 'ADJ';
9582: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9583: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9584: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9585: );
9586: END IF;
9587:
9588: --Frt boundary is part of line boundary estimation because frt over revenue line

Line 9640: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

9636: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9637: l_ra_ar_gt.activity_bucket := 'ADJ';
9638: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9639: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9640: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9641: );
9642: END IF;
9643: END line_boundary;
9644:

Line 9657: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;

9653: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
9654: IS
9655: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9656: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
9657: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
9658: BEGIN
9659: IF NVL(p_adj_rec.tax_adjusted,0) <> 0 AND
9660: NVL(p_sum_line_tax_orig_amt,0) = 0 AND
9661: NVL(p_sum_line_tax_rem_amt,0) = 0

Line 9710: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

9706: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9707: l_ra_ar_gt.activity_bucket := 'ADJ';
9708: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9709: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9710: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9711: );
9712: END IF;
9713: END tax_boundary;
9714: /*

Line 9944: SELECT /*+ leading(B) INDEX(B ra_ar_n1) INDEX(D RA_AR_AMOUNTS_GT_N1)*/

9940: p_customer_trx_id IN NUMBER,
9941: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
9942: IS
9943: CURSOR c_read_for_gline IS
9944: SELECT /*+ leading(B) INDEX(B ra_ar_n1) INDEX(D RA_AR_AMOUNTS_GT_N1)*/
9945: b.group_id groupe,
9946: -- ADJ AND APP
9947: --Base
9948: d.base_pro_amt,

Line 10038: RA_AR_AMOUNTS_GT d

10034: b.FROM_CURRENCY ,
10035: -- Rowid
10036: b.rowid
10037: FROM RA_AR_GT b,
10038: RA_AR_AMOUNTS_GT d
10039: WHERE b.gt_id = p_gt_id
10040: AND b.ref_customer_trx_id = p_customer_trx_id
10041: AND b.gp_level = 'GPL'
10042: AND d.gt_id = b.gt_id