APPS.ZX_GL_EXTRACT_PKG dependencies on GL_CODE_COMBINATIONS

Line 907: gl_code_combinations gcc2,

903: l_table_list_gl :=
904: ' FROM
905: fnd_document_sequences seq,
906: -- gl_tax_options gto,
907: gl_code_combinations gcc2,
908: gl_je_lines gjl2,
909: -- ar_ap_tax_codes_v tax,
910: zx_rates_vl zx_rate,
911: zx_taxes_vl zx_tax,

Line 912: gl_code_combinations gcc1,

908: gl_je_lines gjl2,
909: -- ar_ap_tax_codes_v tax,
910: zx_rates_vl zx_rate,
911: zx_taxes_vl zx_tax,
912: gl_code_combinations gcc1,
913: gl_je_lines gjl1,
914: gl_je_batches gjb,
915: gl_je_headers gjh,
916: gl_period_statuses gps ';

Line 1121: gl_code_combinations gcc2,

1117: l_table_list_gl :=
1118: ' from
1119: fnd_document_sequences seq,
1120: -- gl_tax_options gto,
1121: gl_code_combinations gcc2,
1122: gl_je_lines gjl2,
1123: --ar_ap_tax_codes_v tax,
1124: zx_rates_vl zx_rate,
1125: zx_taxes_vl zx_tax,

Line 1126: gl_code_combinations gcc1,

1122: gl_je_lines gjl2,
1123: --ar_ap_tax_codes_v tax,
1124: zx_rates_vl zx_rate,
1125: zx_taxes_vl zx_tax,
1126: gl_code_combinations gcc1,
1127: gl_je_lines gjl1,
1128: gl_je_batches gjb,
1129: gl_je_headers gjh,
1130: gl_period_statuses gps ';

Line 2250: FROM gl_code_combinations

2246: AND act.detail_tax_line_id(+) = det.detail_tax_line_id;
2247:
2248: CURSOR account_type_cur(c_ccid number) IS
2249: SELECT account_type
2250: FROM gl_code_combinations
2251: WHERE code_combination_id = c_ccid;
2252:
2253: l_balancing_segment VARCHAR2(25);
2254: l_accounting_segment VARCHAR2(25);

Line 2604: ' FROM GL_CODE_COMBINATIONS '||

2600: L_BAL_SEG_VAL := '';
2601: L_ACCT_SEG_VAL := '';
2602:
2603: L_SQL_STATEMENT1 := ' SELECT '||P_BALANCING_SEGMENT ||
2604: ' FROM GL_CODE_COMBINATIONS '||
2605: ' WHERE CODE_COMBINATION_ID = :L_CCID ';
2606:
2607: L_SQL_STATEMENT2 := ' SELECT '||P_ACCOUNTING_SEGMENT ||
2608: ' FROM GL_CODE_COMBINATIONS '||

Line 2608: ' FROM GL_CODE_COMBINATIONS '||

2604: ' FROM GL_CODE_COMBINATIONS '||
2605: ' WHERE CODE_COMBINATION_ID = :L_CCID ';
2606:
2607: L_SQL_STATEMENT2 := ' SELECT '||P_ACCOUNTING_SEGMENT ||
2608: ' FROM GL_CODE_COMBINATIONS '||
2609: ' WHERE CODE_COMBINATION_ID = :L_CCID ';
2610:
2611:
2612: OPEN TAXABLE_ACCT_CURSOR(P_TRX_ID, P_TAX_CODE_ID, P_TRX_LINE_ID);