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:

Line 210: FROM zx_condition_groups_b

206: BEGIN
207:
208: SELECT condition_group_id, condition_group_code
209: INTO l_condition_grp_id, l_condition_grp_cd
210: FROM zx_condition_groups_b
211: WHERE condition_group_code = l_tax_code;
212:
213:
214: EXCEPTION WHEN OTHERS THEN

Line 396: FROM zx_condition_groups_b

392: WHERE vat.vat_tax_id = l_tax_group_id;
393:
394: SELECT condition_group_id, condition_group_code
395: INTO l_condition_grp_id, l_condition_grp_cd
396: FROM zx_condition_groups_b
397: WHERE condition_group_code = l_tax_group_code|| decode(l_tax_constraint_id,NULL, '', '~'||l_tax_constraint_id);
398:
399:
400: EXCEPTION WHEN OTHERS THEN

Line 534: FROM zx_condition_groups_b

530: WHERE vat.vat_tax_id = l_tax_group_id;
531:
532: SELECT condition_group_id, condition_group_code
533: INTO l_condition_grp_id, l_condition_grp_cd
534: FROM zx_condition_groups_b
535: WHERE condition_group_code = l_tax_group_code|| decode(l_tax_constraint_id,NULL, '', '~'||l_tax_constraint_id);
536:
537: EXCEPTION WHEN OTHERS THEN
538: arp_util_tax.debug('Case 4:error for tax '||l_child_tax_code||' error:'||sqlerrm);

Line 1013: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,

1009: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE ,
1010: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1011: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE ,
1012: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1013: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1014: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1015: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1016: x_return_status OUT NOCOPY VARCHAR2 ) IS
1017: