DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_LINES_POPU_PKG dependencies on ZX_LINES_DET_FACTORS

Line 2290: zx_lines_det_factors G

2286: 1,
2287: L.legal_reporting_status,
2288: L.account_source_tax_rate_id
2289: FROM ZX_LINES L,
2290: zx_lines_det_factors G
2291: WHERE G.application_id = p_event_class_rec.application_id AND
2292: G.entity_code = p_event_class_rec.entity_code AND
2293: G.event_class_code = p_event_class_rec.event_class_code AND
2294: -- G.trx_id = p_event_class_rec.trx_id AND

Line 2996: zx_lines_det_factors G

2992: 1,
2993: legal_reporting_status,
2994: L.account_source_tax_rate_id
2995: FROM zx_lines L,
2996: zx_lines_det_factors G
2997: WHERE G.application_id = p_event_class_rec.application_id
2998: AND G.entity_code = p_event_class_rec.entity_code
2999: AND G.event_class_code = p_event_class_rec.event_class_code
3000: AND G.trx_id = p_event_class_rec.trx_id

Line 3788: zx_lines_det_factors G

3784: 1,
3785: legal_reporting_status,
3786: L.account_source_tax_rate_id
3787: FROM zx_lines L,
3788: zx_lines_det_factors G
3789: WHERE G.application_id = p_event_class_rec.application_id
3790: AND G.entity_code = p_event_class_rec.entity_code
3791: AND G.event_class_code = p_event_class_rec.event_class_code
3792: -- AND G.trx_id = p_event_class_rec.trx_id

Line 4491: zx_lines_det_factors G

4487: 1,
4488: legal_reporting_status,
4489: L.account_source_tax_rate_id
4490: FROM ZX_LINES L,
4491: zx_lines_det_factors G
4492: WHERE G.application_id = p_event_class_rec.application_id AND
4493: G.entity_code = p_event_class_rec.entity_code AND
4494: G.event_class_code = p_event_class_rec.event_class_code AND
4495: -- G.trx_id = p_event_class_rec.trx_id AND

Line 5179: zx_lines_det_factors G

5175: 1,
5176: L.legal_reporting_status,
5177: L.account_source_tax_rate_id
5178: FROM ZX_LINES L,
5179: zx_lines_det_factors G
5180: WHERE G.application_id = p_event_class_rec.application_id AND
5181: G.entity_code = p_event_class_rec.entity_code AND
5182: G.event_class_code = p_event_class_rec.event_class_code AND
5183: -- G.trx_id = p_event_class_rec.trx_id AND

Line 5286: zx_lines_det_factors trx_line

5282: tax_line.tax_id,
5283: tax_line.tax_hold_released_code,
5284: tax_line.Rounding_Rule_Code
5285: FROM ZX_DETAIL_TAX_LINES_GT tax_line,
5286: zx_lines_det_factors trx_line
5287: WHERE tax_line.application_id = p_event_class_rec.application_id
5288: AND tax_line.entity_code = p_event_class_rec.entity_code
5289: AND tax_line.event_class_code = p_event_class_rec.event_class_code
5290: AND tax_line.trx_id = p_event_class_rec.trx_id

Line 5346: FROM zx_lines_det_factors line

5342: AND gt.orig_tax_amt_tax_curr IS NOT NULL
5343: AND gt.mrc_tax_line_flag = 'N'
5344: AND EXISTS
5345: (SELECT 1
5346: FROM zx_lines_det_factors line
5347: WHERE line.application_id = p_event_class_rec.application_id
5348: AND line.entity_code = p_event_class_rec.entity_code
5349: AND line.event_class_code = p_event_class_rec.event_class_code
5350: AND line.event_id = p_event_class_rec.event_id