APPS.PN_EXP_TO_AR dependencies on RA_BATCH_SOURCES

Line 56: FROM ra_batch_sources

52: SELECT name,
53: rev_acc_allocation_rule,
54: allow_sales_credit_flag,
55: derive_date_flag
56: FROM ra_batch_sources
57: WHERE batch_source_id = 24;
58:
59: CURSOR get_tax_code (p_tax_code_id number) is
60: SELECT tax_code

Line 97: RA_BATCH_SOURCES bs

93: SELECT gb.COLUMN_ID
94: FROM RA_GROUP_BYS gb,
95: RA_GROUPING_TRX_TYPES gt,
96: RA_GROUPING_RULES gr,
97: RA_BATCH_SOURCES bs
98: WHERE gb.GROUPING_TRX_TYPE_ID = gt.GROUPING_TRX_TYPE_ID
99: AND gt.GROUPING_RULE_ID = gr.GROUPING_RULE_ID
100: AND gr.GROUPING_RULE_ID = bs.GROUPING_RULE_ID
101: AND bs.BATCH_SOURCE_ID = 24

Line 585: l_batch_name RA_BATCH_SOURCES.NAME%TYPE;

581: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
582: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
583: l_last_update_date DATE := sysdate;
584: l_context VARCHAR2(200);
585: l_batch_name RA_BATCH_SOURCES.NAME%TYPE;
586: l_precision NUMBER;
587: l_ext_precision NUMBER;
588: l_min_acct_unit NUMBER;
589: t_count NUMBER := 0;

Line 594: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;

590: e_count NUMBER := 0;
591: s_count NUMBER := 0;
592: l_tax_code AR_VAT_TAX.tax_code%TYPE;
593: l_tax_classification_code pn_payment_terms.tax_classification_code%TYPE;
594: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;
595: l_rev_flag VARCHAR2(1);
596: l_rec_flag VARCHAR2(1);
597: l_ast_flag VARCHAR2(1);
598: l_rec_cnt NUMBER;

Line 624: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;

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;
628: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

Line 1884: l_batch_name RA_BATCH_SOURCES.name%TYPE;

1880: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1881: l_last_update_date DATE := sysdate;
1882: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE ;
1883: l_context VARCHAR2(2000);
1884: l_batch_name RA_BATCH_SOURCES.name%TYPE;
1885: l_precision NUMBER;
1886: l_ext_precision NUMBER;
1887: l_min_acct_unit NUMBER;
1888: t_count NUMBER := 0;

Line 1892: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;

1888: t_count NUMBER := 0;
1889: e_count NUMBER := 0;
1890: s_count NUMBER := 0;
1891: l_tax_code AR_VAT_TAX.tax_code%TYPE;
1892: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;
1893: l_rev_flag VARCHAR2(1);
1894: l_rec_flag VARCHAR2(1);
1895: l_ast_flag VARCHAR2(1);
1896: l_rec_cnt NUMBER;

Line 1919: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;

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;
1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;