APPS.ZX_JE_EXTRACT_PKG dependencies on ZX_LINES

Line 45: | IN: p_tax_line_id zx_lines.tax_line_id%TYPE |

41: | |
42: | Called from POPULATE_JE_AR and POPULATE_JE_AP. |
43: | |
44: | Parameters : |
45: | IN: p_tax_line_id zx_lines.tax_line_id%TYPE |
46: | IN OUT p_rep_code zx_reporting_codes_b.reporting_code_char_value%TYPE |
47: | IN OUT p_rep_name zx_reporting_codes_tl.reporting_code_name%TYPE |
48: +===========================================================================*/
49:

Line 51: (p_tax_line_id IN zx_lines.tax_line_id%TYPE,

47: | IN OUT p_rep_name zx_reporting_codes_tl.reporting_code_name%TYPE |
48: +===========================================================================*/
49:
50: Procedure get_emea_rep_code_name
51: (p_tax_line_id IN zx_lines.tax_line_id%TYPE,
52: p_rep_code IN OUT NOCOPY zx_reporting_codes_b.reporting_code_char_value%TYPE,
53: p_rep_name IN OUT NOCOPY zx_reporting_codes_tl.reporting_code_name%TYPE
54: )
55: IS

Line 70: zx_lines zxl

66: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 1 order_num
67: FROM zx_report_codes_assoc rep_assoc,
68: zx_reporting_types_b rep_types,
69: zx_reporting_codes_vl rep_codes,
70: zx_lines zxl
71: WHERE zxl.tax_line_id = p_tax_line_id
72: AND rep_types.reporting_type_code = 'INTRA_EU_VAT_TRANSACTION_TYPE'
73: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id
74: AND rep_assoc.entity_id = NVL(zxl.direct_rate_result_id, zxl.rate_result_id)

Line 85: zx_lines zxl

81: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 2 order_num
82: FROM zx_report_codes_assoc rep_assoc,
83: zx_reporting_types_b rep_types,
84: zx_reporting_codes_vl rep_codes,
85: zx_lines zxl
86: WHERE zxl.tax_line_id = p_tax_line_id
87: AND rep_types.reporting_type_code = 'INTRA_EU_VAT_TRANSACTION_TYPE'
88: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id
89: AND rep_assoc.entity_id = zxl.tax_rate_id

Line 100: zx_lines zxl

96: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 3 order_num
97: FROM zx_report_codes_assoc rep_assoc,
98: zx_reporting_types_b rep_types,
99: zx_reporting_codes_vl rep_codes,
100: zx_lines zxl
101: WHERE zxl.tax_line_id = p_tax_line_id
102: AND rep_types.reporting_type_code = 'INTRA_EU_VAT_TRANSACTION_TYPE'
103: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id
104: AND rep_assoc.entity_id = zxl.status_result_id

Line 361: from zx_lines lines

357: BEGIN
358: -- Directly populate the tax line id from Base Doc on which application is done.
359: UPDATE zx_rep_trx_detail_t dtl
360: set dtl.tax_line_id = (select min (tax_line_id)
361: from zx_lines lines
362: where lines.application_id = 222
363: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID
364: and lines.trx_line_id = dtl.APPLIED_TO_TRX_LINE_ID
365: and lines.tax_rate_id = dtl.tax_rate_id

Line 377: from zx_lines lines

373:
374: -- Directly populate the tax line id from Adjustment Doc
375: UPDATE zx_rep_trx_detail_t dtl
376: set dtl.tax_line_id = (select min (tax_line_id)
377: from zx_lines lines
378: where lines.application_id = 222
379: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID
380: and lines.trx_line_id = dtl.APPLIED_TO_TRX_LINE_ID
381: AND lines.tax_rate_id = dtl.tax_rate_id