DBA Data[Home] [Help]

APPS.FV_GTAS_TRX_REGISTER dependencies on AR_DISTRIBUTIONS_ALL

Line 1545: l_ar_source_id ar_distributions_all.source_id%TYPE;

1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;
1544: l_event_type_code xla_ae_headers.event_type_code%TYPE;
1545: l_ar_source_id ar_distributions_all.source_id%TYPE;
1546: l_ar_source_table ar_distributions_all.source_table%TYPE;
1547: l_ar_source_type ar_distributions_all.source_type%TYPE;
1548: l_reimb_act_select VARCHAR2(100) ;
1549: l_reimb_agree_seg_val VARCHAR2(30) ;

Line 1546: l_ar_source_table ar_distributions_all.source_table%TYPE;

1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;
1544: l_event_type_code xla_ae_headers.event_type_code%TYPE;
1545: l_ar_source_id ar_distributions_all.source_id%TYPE;
1546: l_ar_source_table ar_distributions_all.source_table%TYPE;
1547: l_ar_source_type ar_distributions_all.source_type%TYPE;
1548: l_reimb_act_select VARCHAR2(100) ;
1549: l_reimb_agree_seg_val VARCHAR2(30) ;
1550:

Line 1547: l_ar_source_type ar_distributions_all.source_type%TYPE;

1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;
1544: l_event_type_code xla_ae_headers.event_type_code%TYPE;
1545: l_ar_source_id ar_distributions_all.source_id%TYPE;
1546: l_ar_source_table ar_distributions_all.source_table%TYPE;
1547: l_ar_source_type ar_distributions_all.source_type%TYPE;
1548: l_reimb_act_select VARCHAR2(100) ;
1549: l_reimb_agree_seg_val VARCHAR2(30) ;
1550:
1551:

Line 2583: FROM ar_distributions_all

2579: source_type
2580: INTO l_ar_source_id,
2581: l_ar_source_table,
2582: l_ar_source_type
2583: FROM ar_distributions_all
2584: WHERE line_id = l_source_distribution_id_num_1;
2585: log(l_module, 'l_ar_source_id='||l_ar_source_id);
2586: log(l_module, 'l_ar_source_table='||l_ar_source_table);
2587: log(l_module, 'l_ar_source_type='||l_ar_source_type);

Line 2788: FROM ar_distributions_all

2784: source_type
2785: INTO l_ar_source_id,
2786: l_ar_source_table,
2787: l_ar_source_type
2788: FROM ar_distributions_all
2789: WHERE line_id = l_source_distribution_id_num_1;
2790: log(l_module, 'l_ar_source_id='||l_ar_source_id);
2791: log(l_module, 'l_ar_source_table='||l_ar_source_table);
2792: log(l_module, 'l_ar_source_type='||l_ar_source_type);