APPS.ZX_TRL_ALLOCATIONS_PKG dependencies on ZX_LINES_S

Line 95: SELECT zx_lines_s.nextval

91: AND TRX_ID = p_trx_id
92: AND TRX_LINE_ID = p_trx_line_id
93: AND TRX_LEVEL_TYPE = p_trx_level_type;
94:
95: SELECT zx_lines_s.nextval
96: INTO l_tax_line_id
97: FROM dual;
98:
99: SELECT distinct precision,minimum_accountable_unit,trx_currency_code

Line 101: FROM zx_lines_det_factors zxd, zx_lines_summary zxs

97: FROM dual;
98:
99: SELECT distinct precision,minimum_accountable_unit,trx_currency_code
100: INTO l_precision, l_minimum_accountable_unit, l_trx_currency_code
101: FROM zx_lines_det_factors zxd, zx_lines_summary zxs
102: WHERE zxd.trx_id = zxs.trx_id
103: AND zxs.summary_tax_line_id = p_summary_tax_line_id;
104:
105:

Line 468: FROM ZX_LINES_SUMMARY

464: END IF;
465:
466: SELECT TAX_AMT
467: INTO l_summary_tax_amt
468: FROM ZX_LINES_SUMMARY
469: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
470:
471: IF (g_level_statement >= g_current_runtime_level ) THEN
472: FND_LOG.STRING(g_level_statement,

Line 732: SELECT zx_lines_s.nextval

728: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
729: 'status id : ' || to_char(l_status_id)) ;
730: END IF;
731:
732: SELECT zx_lines_s.nextval
733: INTO l_tax_line_id
734: FROM dual;
735:
736: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1345: SELECT zx_lines_s.nextval

1341: RETURN;
1342:
1343: END;
1344:
1345: SELECT zx_lines_s.nextval
1346: INTO l_tax_line_id
1347: FROM dual;
1348:
1349: IF (g_level_procedure >= g_current_runtime_level ) THEN