APPS.ZX_MIGRATE_TAX_DEF dependencies on AP_TAX_RECVRY_RATES_ALL

Line 5912: ap_tax_recvry_rates_all rates

5908: FROM
5909: ap_tax_codes_all codes,
5910: zx_rates_b zx_rates,
5911: ap_tax_recvry_rules_all rules,
5912: ap_tax_recvry_rates_all rates
5913: WHERE
5914: codes.tax_recovery_rule_id = rules.rule_id
5915: AND rules.rule_id = rates.rule_id
5916: --Added following conditions for Sync process

Line 9050: ap_tax_recvry_rates_all RATES

9046: RATES.CONCATENATED_SEGMENT_HIGH VALUE_HIGH
9047:
9048: FROM
9049: ap_tax_recvry_rules_all RULES,
9050: ap_tax_recvry_rates_all RATES
9051: WHERE
9052: RULES.rule_id = rates.rule_id
9053: --Added following conditions for Sync process
9054: AND rates.rate_id = nvl(p_rate_id,rates.rate_id)

Line 9078: ap_tax_recvry_rates_all RATES

9074: NULL VALUE_LOW ,
9075: NULL VALUE_HIGH
9076: FROM
9077: ap_tax_recvry_rules_all RULES,
9078: ap_tax_recvry_rates_all RATES
9079: WHERE
9080: RULES.rule_id = rates.rule_id
9081: --Added following conditions for Sync process
9082: AND rates.rate_id = nvl(p_rate_id,rates.rate_id)

Line 9197: ap_tax_recvry_rates_all RATES

9193: ap_tax_recvry_rules_all RULES,
9194: --ap_system_parameters_all ASP,
9195: gl_sets_of_books SOB,
9196: financials_system_params_all FSP,
9197: ap_tax_recvry_rates_all RATES
9198: WHERE
9199: rules.org_id = fsp.org_id
9200: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9201: AND RULES.RULE_ID = RATES.RULE_ID

Line 9215: ap_tax_recvry_rates_all RATES1

9211: RULES1.RULE_ID,
9212: RATES1.RATE_ID
9213: FROM
9214: ap_tax_recvry_rules_all RULES1,
9215: ap_tax_recvry_rates_all RATES1
9216: WHERE
9217: RULES1.rule_id = RATES1.rule_id
9218: ) TEMP_GROUPS
9219: WHERE

Line 9328: ap_tax_recvry_rates_all RATES

9324: ap_tax_recvry_rules_all RULES,
9325: --ap_system_parameters_all ASP,
9326: gl_sets_of_books SOB,
9327: financials_system_params_all FSP,
9328: ap_tax_recvry_rates_all RATES
9329: WHERE
9330: rules.org_id = fsp.org_id
9331: AND rules.org_id = l_org_id
9332: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 9347: ap_tax_recvry_rates_all RATES1

9343: RULES1.RULE_ID,
9344: RATES1.RATE_ID
9345: FROM
9346: ap_tax_recvry_rules_all RULES1,
9347: ap_tax_recvry_rates_all RATES1
9348: WHERE
9349: RULES1.rule_id = RATES1.rule_id
9350: ) TEMP_GROUPS
9351: WHERE

Line 9530: from ap_tax_recvry_rates_all

9526: END TAX_RULE_CODE,
9527: RATES.TAX TAX ,
9528: RATES.TAX_REGIME_CODE TAX_REGIME_CODE,
9529: (select min(start_date)
9530: from ap_tax_recvry_rates_all
9531: where rule_id = RULES.rule_id) EFFECTIVE_FROM,
9532: ptp.party_tax_profile_id CONTENT_OWNER_ID
9533: FROM
9534: ap_tax_codes_all codes,

Line 9646: from ap_tax_recvry_rates_all

9642: END TAX_RULE_CODE,
9643: RATES.TAX TAX ,
9644: RATES.TAX_REGIME_CODE TAX_REGIME_CODE,
9645: (select min(start_date)
9646: from ap_tax_recvry_rates_all
9647: where rule_id = RULES.rule_id) EFFECTIVE_FROM,
9648: ptp.party_tax_profile_id CONTENT_OWNER_ID
9649: FROM
9650: ap_tax_codes_all codes,

Line 9826: ap_tax_recvry_rates_all AP_RATES,

9822: END ENABLED_FLAG --ENABLED_FLAG
9823: FROM
9824: AP_TAX_CODES_ALL CODES,
9825: ap_tax_recvry_rules_all AP_RULES,
9826: ap_tax_recvry_rates_all AP_RATES,
9827: ZX_RATES_B ZX_RATES,
9828: ZX_RULES_B ZX_RULES,
9829: ZX_CONDITION_GROUPS_B GROUPS,
9830: zx_party_tax_profile ptp

Line 9853: ap_tax_recvry_rates_all RATES1

9849: RULES1.RULE_ID,
9850: RATES1.RATE_ID
9851: FROM
9852: ap_tax_recvry_rules_all RULES1,
9853: ap_tax_recvry_rates_all RATES1
9854: WHERE
9855: RULES1.rule_id = RATES1.rule_id
9856: ) TEMP_GROUPS
9857: WHERE

Line 9965: ap_tax_recvry_rates_all AP_RATES,

9961: END ENABLED_FLAG --ENABLED_FLAG
9962: FROM
9963: AP_TAX_CODES_ALL CODES,
9964: ap_tax_recvry_rules_all AP_RULES,
9965: ap_tax_recvry_rates_all AP_RATES,
9966: ZX_RATES_B ZX_RATES,
9967: ZX_RULES_B ZX_RULES,
9968: ZX_CONDITION_GROUPS_B GROUPS,
9969: zx_party_tax_profile ptp

Line 9993: ap_tax_recvry_rates_all RATES1

9989: RULES1.RULE_ID,
9990: RATES1.RATE_ID
9991: FROM
9992: ap_tax_recvry_rules_all RULES1,
9993: ap_tax_recvry_rates_all RATES1
9994: WHERE
9995: RULES1.rule_id = RATES1.rule_id
9996: ) TEMP_GROUPS
9997: WHERE