APPS.PN_EXP_TO_AR dependencies on RA_CUST_TRX_TYPES_ALL

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 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 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;