APPS.ZX_MIG_GL_TAX_OPTIONS_PKG dependencies on ZX_ACCOUNT_RATES_TMP

Line 162: Into zx_account_rates_tmp

158: arp_util_tax.debug('zx_mig_gl_tax_options_header(+)');
159: END IF;
160:
161: Insert ALL
162: Into zx_account_rates_tmp
163: (
164: LEDGER_ID ,
165: CONTENT_OWNER_ID ,
166: ACCOUNT_SEGMENT_VALUE ,

Line 292: From zx_account_rates_tmp -- Bug 6671444

288: ptp.party_type_code = 'OU' and
289: opt.ledger_id =nvl(P_Ledger_Id,opt.ledger_id) and --added for sync
290: decode(l_multi_org_flag,'N',l_org_id,opt.org_id) =nvl(P_Org_id, decode(l_multi_org_flag,'N',l_org_id,opt.org_id)) and --added for Sync
291: NOT EXISTS ( Select 1
292: From zx_account_rates_tmp -- Bug 6671444
293: Where ledger_id = opt.ledger_id
294: and content_owner_id = ptp.PARTY_TAX_PROFILE_ID
295: and account_segment_value is null
296: and tax_class is NULL );

Line 340: Into zx_account_rates_tmp

336: arp_util_tax.debug('zx_mig_gl_tax_options_nt(+)');
337: END IF;
338:
339: Insert ALL
340: Into zx_account_rates_tmp
341: (
342: LEDGER_ID ,
343: CONTENT_OWNER_ID ,
344: ACCOUNT_SEGMENT_VALUE ,

Line 475: From zx_account_rates_tmp --Bug 6671444

471: decode(l_multi_org_flag,'N',l_org_id,accounts.org_id) =nvl(P_Org_id,decode(l_multi_org_flag,'N',l_org_id,accounts.org_id)) and
472: --added for Sync
473: accounts.account_segment_value = nvl(P_Account_Segment_Value,accounts.account_segment_value) and --added for sync
474: NOT EXISTS ( Select 1
475: From zx_account_rates_tmp --Bug 6671444
476: Where ledger_id = opt.ledger_id
477: and content_owner_id = ptp.party_tax_profile_id
478: and account_segment_value = accounts.account_segment_value
479: and tax_class = 'NON_TAXABLE' );

Line 522: Into zx_account_rates_tmp

518: arp_util_tax.debug('zx_mig_gl_tax_options_ap(+)');
519: END IF;
520:
521: Insert ALL
522: Into zx_account_rates_tmp
523: (
524: LEDGER_ID ,
525: CONTENT_OWNER_ID ,
526: ACCOUNT_SEGMENT_VALUE ,

Line 657: From zx_account_rates_tmp --Bug 6671444

653: nvl(rates.tax_class,'INPUT') = 'INPUT' and
654: opt.ledger_id =nvl(P_Ledger_Id,opt.ledger_id) and --added for sync
655: decode(l_multi_org_flag,'N',l_org_id,opt.org_id)=nvl(P_Org_id,decode(l_multi_org_flag,'N',l_org_id,opt.org_id)) and --added for Sync
656: NOT EXISTS ( Select 1
657: From zx_account_rates_tmp --Bug 6671444
658: Where ledger_id = opt.ledger_id
659: and content_owner_id = rates.content_owner_id
660: and account_segment_value is null
661: and tax_class = 'INPUT' );

Line 664: Into zx_account_rates_tmp

660: and account_segment_value is null
661: and tax_class = 'INPUT' );
662:
663: Insert ALL
664: Into zx_account_rates_tmp
665: (
666: LEDGER_ID ,
667: CONTENT_OWNER_ID ,
668: ACCOUNT_SEGMENT_VALUE ,

Line 867: From zx_account_rates_tmp --Bug 6671444

863: decode(l_multi_org_flag,'N',l_org_id,accounts.org_id) =nvl(P_Org_id,decode(l_multi_org_flag,'N',l_org_id,accounts.org_id)) and
864: --added for Sync
865: accounts.account_segment_value = nvl(P_Account_Segment_Value,accounts.account_segment_value) and --added for sync
866: NOT EXISTS ( Select 1
867: From zx_account_rates_tmp --Bug 6671444
868: Where ledger_id = opt.ledger_id
869: and content_owner_id = rates.content_owner_id
870: and account_segment_value = accounts.account_segment_value
871: and tax_class = 'INPUT' );

Line 913: Into zx_account_rates_tmp

909: arp_util_tax.debug('zx_mig_gl_tax_options_ar(+)');
910: END IF;
911:
912: Insert ALL
913: Into zx_account_rates_tmp
914: (
915: LEDGER_ID ,
916: CONTENT_OWNER_ID ,
917: ACCOUNT_SEGMENT_VALUE ,

Line 1050: From zx_account_rates_tmp --Bug 6671444

1046: opt.ledger_id =nvl(P_Ledger_Id,opt.ledger_id) and --added for sync
1047: decode(l_multi_org_flag,'N',l_org_id,opt.org_id) =nvl(P_Org_id,decode(l_multi_org_flag,'N',l_org_id,opt.org_id)) and
1048: --added for Sync
1049: NOT EXISTS ( Select 1
1050: From zx_account_rates_tmp --Bug 6671444
1051: Where ledger_id = opt.ledger_id
1052: and content_owner_id = rates.content_owner_id
1053: and account_segment_value is null
1054: and tax_class = 'OUTPUT' );

Line 1057: Into zx_account_rates_tmp

1053: and account_segment_value is null
1054: and tax_class = 'OUTPUT' );
1055:
1056: Insert ALL
1057: Into zx_account_rates_tmp
1058: (
1059: LEDGER_ID ,
1060: CONTENT_OWNER_ID ,
1061: ACCOUNT_SEGMENT_VALUE ,

Line 1261: From zx_account_rates_tmp --Bug 6671444

1257: decode(l_multi_org_flag,'N',l_org_id,accounts.org_id) =nvl(P_Org_id,decode(l_multi_org_flag,'N',l_org_id,accounts.org_id)) and
1258: --added for Sync
1259: accounts.account_segment_value = nvl(P_Account_Segment_Value,accounts.account_segment_value) and --added for sync
1260: NOT EXISTS ( Select 1
1261: From zx_account_rates_tmp --Bug 6671444
1262: Where ledger_id = opt.ledger_id
1263: and content_owner_id = rates.content_owner_id
1264: and account_segment_value = accounts.account_segment_value
1265: and tax_class = 'OUTPUT' );