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 589: l_batch_name RA_BATCH_SOURCES.NAME%TYPE;

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

Line 598: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;

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

Line 630: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;

626: l_rec_insert_flag BOOLEAN := TRUE;
627: l_valid_rec_accs BOOLEAN := TRUE;
628: l_grp NUMBER;
629: l_post_to_gl RA_CUST_TRX_TYPES_ALL.POST_TO_GL%TYPE;
630: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
631: l_rule_start_date RA_INTERFACE_LINES.RULE_START_DATE%TYPE := NULL;
632: l_count_grp INTEGER;
633: l_rows_grp INTEGER;
634: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

Line 1930: l_batch_name RA_BATCH_SOURCES.name%TYPE;

1926: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1927: l_last_update_date DATE := sysdate;
1928: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE ;
1929: l_context VARCHAR2(2000);
1930: l_batch_name RA_BATCH_SOURCES.name%TYPE;
1931: l_precision NUMBER;
1932: l_ext_precision NUMBER;
1933: l_min_acct_unit NUMBER;
1934: t_count NUMBER := 0;

Line 1938: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;

1934: t_count NUMBER := 0;
1935: e_count NUMBER := 0;
1936: s_count NUMBER := 0;
1937: l_tax_code AR_VAT_TAX.tax_code%TYPE;
1938: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;
1939: l_rev_flag VARCHAR2(1);
1940: l_rec_flag VARCHAR2(1);
1941: l_ast_flag VARCHAR2(1);
1942: l_rec_cnt NUMBER;

Line 1965: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;

1961: l_lease_id NUMBER := 0;
1962: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1963: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
1964: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;
1965: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1966: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1967: l_rows_nogrp INTEGER;
1968: l_count_nogrp INTEGER;
1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;