APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_CONDITION_GROUPS_B

Line 7923: FROM zx_condition_groups_b cg,

7919: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7920: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7921: IS
7922: SELECT cg.constraint_id
7923: FROM zx_condition_groups_b cg,
7924: ar_tax_conditions_all tc
7925: WHERE cg.condition_group_code like c_tax_classification_code||'~'||'%'
7926: AND cg.enabled_flag = 'Y'
7927: AND cg.constraint_id IS NOT NULL

Line 7936: -- FROM zx_condition_groups_b cg

7932: -- CURSOR get_constraints_csr
7933: -- (c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE)
7934: -- IS
7935: -- SELECT cg.CONSTRAINT_ID
7936: -- FROM zx_condition_groups_b cg
7937: -- WHERE cg.CONDITION_GROUP_CODE like c_tax_classification_code||'~'||'%'
7938: -- AND cg.enabled_flag = 'Y'
7939: -- AND cg.constraint_id IS NOT NULL;
7940: --

Line 7947: -- FROM zx_condition_groups_b cg,

7943: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7944: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7945: -- IS
7946: -- SELECT cg.constraint_id
7947: -- FROM zx_condition_groups_b cg,
7948: -- ar_tax_conditions tc
7949: -- WHERE cg.condition_group_code like c_tax_classification_code||'~'||'%'
7950: -- AND cg.enabled_flag = 'Y'
7951: -- AND tc.tax_condition_id = cg.constraint_id

Line 7955: c_condition_group_code zx_condition_groups_b.condition_group_code%TYPE,

7951: -- AND tc.tax_condition_id = cg.constraint_id
7952: -- AND tc.org_id = c_internal_organization_id;
7953:
7954: CURSOR get_candidate_taxes_csr(
7955: c_condition_group_code zx_condition_groups_b.condition_group_code%TYPE,
7956: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
7957: c_tax_class zx_rates_b.tax_class%TYPE,
7958: c_tax_determine_date DATE) IS
7959: SELECT /*+ leading(PR) use_nl(RL) */

Line 8111: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;

8107:
8108:
8109: -- Local variables
8110: --
8111: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8112: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8113: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8114: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8115: l_cec_result BOOLEAN;

Line 8112: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;

8108:
8109: -- Local variables
8110: --
8111: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8112: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8113: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8114: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8115: l_cec_result BOOLEAN;
8116: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;