APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_LINES_DET_FACTORS

Line 3989: FROM zx_lines_det_factors

3985:
3986: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) = 200 THEN
3987: SELECT line_amt
3988: INTO l_orig_amt
3989: FROM zx_lines_det_factors
3990: WHERE application_id =
3991: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3992: AND entity_code =
3993: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)

Line 4005: FROM zx_lines_det_factors

4001: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
4002:
4003: SELECT sum(line_amt)
4004: INTO l_appl_line_amt
4005: FROM zx_lines_det_factors
4006: WHERE applied_from_application_id =
4007: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4008: AND applied_from_entity_code =
4009: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)

Line 8556: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,

8552: x_end_index IN OUT NOCOPY BINARY_INTEGER,
8553: x_return_status OUT NOCOPY VARCHAR2) IS
8554:
8555: CURSOR get_unique_constraint_csr(
8556: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
8557: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
8558: IS
8559: SELECT cg.constraint_id
8560: FROM zx_condition_groups_b cg,

Line 8557: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)

8553: x_return_status OUT NOCOPY VARCHAR2) IS
8554:
8555: CURSOR get_unique_constraint_csr(
8556: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
8557: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
8558: IS
8559: SELECT cg.constraint_id
8560: FROM zx_condition_groups_b cg,
8561: ar_tax_conditions_all tc

Line 8570: -- (c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE)

8566: AND tc.org_id = c_internal_organization_id;
8567:
8568:
8569: -- CURSOR get_constraints_csr
8570: -- (c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE)
8571: -- IS
8572: -- SELECT cg.CONSTRAINT_ID
8573: -- FROM zx_condition_groups_b cg
8574: -- WHERE cg.CONDITION_GROUP_CODE like c_tax_classification_code||'~'||'%'

Line 8580: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,

8576: -- AND cg.constraint_id IS NOT NULL;
8577: --
8578: --
8579: -- CURSOR get_unique_constraint_csr(
8580: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
8581: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
8582: -- IS
8583: -- SELECT cg.constraint_id
8584: -- FROM zx_condition_groups_b cg,

Line 8581: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)

8577: --
8578: --
8579: -- CURSOR get_unique_constraint_csr(
8580: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
8581: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
8582: -- IS
8583: -- SELECT cg.constraint_id
8584: -- FROM zx_condition_groups_b cg,
8585: -- ar_tax_conditions tc

Line 8775: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;

8771: -- Local variables
8772: --
8773: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8774: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8775: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8776: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8777: l_cec_result BOOLEAN;
8778: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8779: l_tax_regime_code_tbl tax_regime_code_tbl;

Line 8776: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;

8772: --
8773: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8774: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8775: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8776: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8777: l_cec_result BOOLEAN;
8778: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8779: l_tax_regime_code_tbl tax_regime_code_tbl;
8780: l_tax_tbl tax_tbl;