APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_CONDITION_GROUPS_B

Line 45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;

41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;
42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;
44:
45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;
46: l_condition_grp_cd zx_condition_groups_b.condition_group_code%TYPE;
47:
48: x_msg_data VARCHAR2(30);
49:

Line 46: l_condition_grp_cd zx_condition_groups_b.condition_group_code%TYPE;

42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;
44:
45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;
46: l_condition_grp_cd zx_condition_groups_b.condition_group_code%TYPE;
47:
48: x_msg_data VARCHAR2(30);
49:
50: --(case 1 cur)-----------------------------------

Line 219: FROM zx_condition_groups_b

215: BEGIN
216:
217: SELECT condition_group_id, condition_group_code
218: INTO l_condition_grp_id, l_condition_grp_cd
219: FROM zx_condition_groups_b
220: WHERE condition_group_code = l_tax_code;
221:
222: EXCEPTION WHEN OTHERS THEN
223: arp_util_tax.debug('Case1: error for tax '||l_tax_code||' Error:'||sqlerrm);

Line 394: FROM zx_condition_groups_b

390: WHERE vat.vat_tax_id = l_tax_group_id;
391:
392: SELECT condition_group_id, condition_group_code
393: INTO l_condition_grp_id, l_condition_grp_cd
394: FROM zx_condition_groups_b
395: WHERE condition_group_code in (Decode(l_tax_constraint_id,NULL,SUBSTRB(l_tax_group_code,1,45)||'-'||'XOP',
396: substrb(l_tax_group_code,1,40)||'~'||l_tax_constraint_id)
397: ,Decode(l_tax_constraint_id,NULL,l_tax_group_code,
398: substrb(l_tax_group_code,1,40)||'~'||l_tax_constraint_id)

Line 521: FROM zx_condition_groups_b

517: WHERE vat.vat_tax_id = l_tax_group_id;
518:
519: SELECT condition_group_id, condition_group_code
520: INTO l_condition_grp_id, l_condition_grp_cd
521: FROM zx_condition_groups_b
522: WHERE condition_group_code in (Decode(l_tax_constraint_id,NULL,SUBSTRB(l_tax_group_code,1,45)||'-'||'XOP',
523: substrb(l_tax_group_code,1,40)||'~'||l_tax_constraint_id)
524: ,Decode(l_tax_constraint_id,NULL,l_tax_group_code,
525: substrb(l_tax_group_code,1,40)||'~'||l_tax_constraint_id)

Line 1049: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,

1045: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE,
1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1047: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE,
1048: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1049: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1050: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1051: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1052: x_return_status OUT NOCOPY VARCHAR2 ) IS
1053: