APPS.ARP_DATES dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 861: ra_cust_trx_line_gl_dist.gl_date%type,

857: PROCEDURE derive_gl_trx_dates_from_rules (
858: p_customer_trx_id IN
859: ra_customer_trx.customer_trx_id%type,
860: p_gl_date IN OUT NOCOPY
861: ra_cust_trx_line_gl_dist.gl_date%type,
862: p_trx_date IN OUT NOCOPY
863: ra_customer_trx.trx_date%type,
864: p_recalculate_tax_flag IN OUT NOCOPY boolean,
865: P_created_from IN ar_trx_header_gt.created_from%type default NULL,

Line 872: l_db_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

868:
869:
870: l_candidate_date date;
871: l_db_trx_date ra_customer_trx.trx_date%type;
872: l_db_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
873:
874: l_trx_date ra_customer_trx.trx_date%type;
875: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
876:

Line 875: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

871: l_db_trx_date ra_customer_trx.trx_date%type;
872: l_db_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
873:
874: l_trx_date ra_customer_trx.trx_date%type;
875: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
876:
877: l_exchange_rate ra_customer_trx.exchange_rate%type;
878: l_currency_code ra_customer_trx.invoice_currency_code%type;
879:

Line 889: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

885: l_period_year number;
886: l_period_num number;
887: l_quarter_num number;
888: l_allow_not_open_flag varchar2(2);
889: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
890: l_defaulting_rule_used varchar2(100);
891: l_error_message varchar2(100);
892:
893: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;

Line 896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

892:
893: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
894:
895: l_trx_rec ra_customer_trx%rowtype;
896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
897:
898:
899: BEGIN
900:

Line 934: ra_cust_trx_line_gl_dist ctlgd

930: l_exchange_rate,
931: l_currency_code,
932: l_invoicing_rule_id
933: FROM ra_customer_trx ct,
934: ra_cust_trx_line_gl_dist ctlgd
935: WHERE ct.customer_trx_id = ctlgd.customer_trx_id
936: AND ct.customer_trx_id = p_customer_trx_id
937: AND ctlgd.account_class = 'REC'
938: AND ctlgd.latest_rec_flag = 'Y';