APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_FORMULA_B_S

Line 333: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S'),

329: IF l_child_precedence <> 1 THEN
330:
331: SELECT DECODE( SIGN( LENGTH(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30),
332: 1,
333: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S'),
334: l_tax_group_code||'_'||l_child_tax_code||'_TB')
335: INTO l_formula_code
336: FROM DUAL;
337:

Line 553: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),

549: -- which will be that of the ParentRegime / ParentTax.
550:
551: SELECT DECODE(SIGN(LENGTH(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30),
552: 1,
553: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),
554: l_tax_group_code||'_'||l_child_tax_code||'_TB')
555: INTO l_formula_code
556: FROM DUAL;
557:

Line 617: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),

613: -- it is in decode of create_formula()
614:
615: SELECT DECODE(SIGN(LENGTH(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30),
616: 1,
617: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),
618: l_tax_group_code||'_'||l_child_tax_code||'_TB')
619: INTO l_formula_code
620: FROM DUAL;
621:

Line 796: zx_formula_b_s.NEXTVAL l_formula_id,

792: p_charge_flag ,
793: p_charge_flag ,
794: p_charge_flag ,
795: p_charge_flag ,
796: zx_formula_b_s.NEXTVAL l_formula_id,
797: p_content_owner_id ,
798: fnd_global.user_id ,
799: SYSDATE ,
800: fnd_global.user_id ,

Line 900: zx_formula_b_s.CURRVAL ,

896: object_version_number
897: )
898: SELECT
899: zx_formula_details_s.NEXTVAL ,
900: zx_formula_b_s.CURRVAL ,
901: p_parent_regime_code ,
902: p_parent_tax_code ,
903: 'ADD' ,
904: 'MIGRATED' ,

Line 956: zx_formula_b_s.CURRVAL ,

952: program_login_id ,
953: object_version_number
954: )
955: SELECT zx_formula_details_s.NEXTVAL ,
956: zx_formula_b_s.CURRVAL ,
957: parent_tax_code ,
958: parent_regime_code ,
959: 'ADD' ,
960: 'MIGRATED' ,