APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_CONDITION_GROUPS_B

Line 8560: FROM zx_condition_groups_b cg,

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
8562: WHERE cg.condition_group_code like substrb(c_tax_classification_code,1,40)||'~'||'%'
8563: AND cg.enabled_flag = 'Y'
8564: AND cg.constraint_id IS NOT NULL

Line 8573: -- FROM zx_condition_groups_b cg

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||'~'||'%'
8575: -- AND cg.enabled_flag = 'Y'
8576: -- AND cg.constraint_id IS NOT NULL;
8577: --

Line 8584: -- FROM zx_condition_groups_b cg,

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
8586: -- WHERE cg.condition_group_code like c_tax_classification_code||'~'||'%'
8587: -- AND cg.enabled_flag = 'Y'
8588: -- AND tc.tax_condition_id = cg.constraint_id

Line 8592: c_condition_group_code zx_condition_groups_b.condition_group_code%TYPE,

8588: -- AND tc.tax_condition_id = cg.constraint_id
8589: -- AND tc.org_id = c_internal_organization_id;
8590:
8591: CURSOR get_candidate_taxes_csr(
8592: c_condition_group_code zx_condition_groups_b.condition_group_code%TYPE,
8593: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8594: c_tax_class zx_rates_b.tax_class%TYPE,
8595: c_tax_determine_date DATE) IS
8596: SELECT tax_regime_code,

Line 8773: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;

8769:
8770:
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;

Line 8774: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;

8770:
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;