APPS.FV_GTAS_TRX_REGISTER dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 1586: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;

1582:
1583: l_sla_hdr_event_id NUMBER;
1584: l_sla_hdr_creation_date DATE;
1585: l_sla_entity_id NUMBER;
1586: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
1587: l_get_trx_part_from_reimb BOOLEAN;
1588:
1589: l_party_fed_nonfed VARCHAR2(1);
1590: l_fed_nonfed VARCHAR2(1);

Line 2732: --customer_trx_line_id will be null in ra_cust_trx_line_gl_dist_all

2728: l_category = 'Debit Memos')
2729: ) THEN
2730: BEGIN
2731: --Bug 7121539
2732: --customer_trx_line_id will be null in ra_cust_trx_line_gl_dist_all
2733: --for account class 'REC', hence using customer_trx_id to get
2734: --details instead of customer_trx_line_id for these distributions
2735: SELECT account_class
2736: INTO l_account_class

Line 2737: FROM ra_cust_trx_line_gl_dist_all

2733: --for account class 'REC', hence using customer_trx_id to get
2734: --details instead of customer_trx_line_id for these distributions
2735: SELECT account_class
2736: INTO l_account_class
2737: FROM ra_cust_trx_line_gl_dist_all
2738: WHERE cust_trx_line_gl_dist_id = l_source_distribution_id_num_1;
2739:
2740: log(l_module,'Account class: '||l_account_class);
2741:

Line 2749: FROM ra_cust_trx_line_gl_dist_all rctgl,

2745: rcth.customer_trx_id
2746: INTO l_reference_4,
2747: l_reference_7,
2748: l_reference_2
2749: FROM ra_cust_trx_line_gl_dist_all rctgl,
2750: ra_customer_trx_lines_all rctl,
2751: ra_customer_trx_all rcth
2752: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2753: AND rctl.customer_trx_line_id = rctgl.customer_trx_line_id

Line 2762: FROM ra_cust_trx_line_gl_dist_all rctgl,

2758: rcth.customer_trx_id
2759: INTO l_reference_4,
2760: l_reference_7,
2761: l_reference_2
2762: FROM ra_cust_trx_line_gl_dist_all rctgl,
2763: ra_customer_trx_all rcth
2764: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2765: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2766: END IF;