APPS.PN_EXP_TO_AR dependencies on RA_CUST_TRX_TYPES

Line 38: FROM ra_cust_trx_types

34: AND org_id = p_org_id;
35:
36: CURSOR get_cust_trx_name (p_cust_trx_type_id number) is
37: SELECT name
38: FROM ra_cust_trx_types
39: WHERE cust_trx_type_id = p_cust_trx_type_id;
40:
41: CURSOR get_term_name (p_term_id number) is
42: SELECT name

Line 106: FROM ra_cust_trx_types_all

102: AND NVL(bs.org_id,-99) = NVL(pn_mo_cache_utils.get_current_org_id,-99); --Bug#6319026
103:
104: CURSOR get_post_to_gl(p_trx_type_id NUMBER, p_org_id NUMBER) IS
105: SELECT post_to_gl
106: FROM ra_cust_trx_types_all
107: WHERE cust_trx_type_id = p_trx_type_id
108: AND org_id = p_org_id;
109:
110: /* Global Flags */

Line 249: PN_DISTRIBUTIONS_ALL pd, RA_CUST_TRX_TYPES_ALL cust_trx,

245: PN_LEASE_DETAILS_ALL pld, HZ_CUST_SITE_USES_ALL hzc,
246: HZ_CUST_SITE_USES_ALL hzc1, HZ_PARTIES party,
247: HZ_CUST_ACCOUNTS_ALL cust_acc, FND_LOOKUPS type_lookup,
248: FND_LOOKUPS purpose_lookup, HR_OPERATING_UNITS ou,
249: PN_DISTRIBUTIONS_ALL pd, RA_CUST_TRX_TYPES_ALL cust_trx,
250: RA_RULES rr
251: WHERE pi.payment_term_id = pt.payment_term_id
252: AND pi.payment_schedule_id = ps.payment_schedule_id
253: AND pi.export_to_ar_flag = ''Y''

Line 576: l_cust_trx_name RA_CUST_TRX_TYPES.NAME%TYPE;

572: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
573: l_desc RA_INTERFACE_LINES.description%TYPE;
574: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;
575: l_sales_credit_id RA_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE;
576: l_cust_trx_name RA_CUST_TRX_TYPES.NAME%TYPE;
577: l_term_name RA_TERMS.NAME%TYPE;
578: l_pay_method_name AR_RECEIPT_METHODS.NAME%TYPE;
579: l_amt NUMBER;
580: l_prior_payment_schedule_id NUMBER := -999;

Line 623: l_post_to_gl RA_CUST_TRX_TYPES_ALL.POST_TO_GL%TYPE;

619: l_item_prcsed NUMBER := 0;
620: l_rec_insert_flag BOOLEAN := TRUE;
621: l_valid_rec_accs BOOLEAN := TRUE;
622: l_grp NUMBER;
623: l_post_to_gl RA_CUST_TRX_TYPES_ALL.POST_TO_GL%TYPE;
624: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
625: l_rule_start_date RA_INTERFACE_LINES.RULE_START_DATE%TYPE := NULL;
626: l_count_grp INTEGER;
627: l_rows_grp INTEGER;

Line 1874: l_cust_trx_name RA_CUST_TRX_TYPES.name%TYPE;

1870: l_acc_rule_freq RA_RULES.frequency%TYPE;
1871: l_desc RA_INTERFACE_LINES.description%TYPE;
1872: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1873: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;
1874: l_cust_trx_name RA_CUST_TRX_TYPES.name%TYPE;
1875: l_term_name RA_TERMS.name%TYPE;
1876: l_pay_method_name AR_RECEIPT_METHODS.name%TYPE;
1877: l_amt NUMBER;
1878: l_prior_payment_schedule_id NUMBER := -999;

Line 1918: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;

1914: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';
1915: l_lease_id NUMBER := 0;
1916: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1917: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
1918: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;
1919: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1920: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1921: l_rows_nogrp INTEGER;
1922: l_count_nogrp INTEGER;