APPS.ZX_SIM_CONDITIONS_PKG dependencies on DUAL

Line 447: From dual;

443: pr_value_high_tab(j) value_high,
444: l_trxlines_rec.trx_line_id trx_line_id,
445: l_trxlines_rec.trx_id trx_id,
446: l_taxlines_rec.summary_tax_line_number tax_line_number
447: From dual;
448:
449: If c_detfactors%isopen Then
450: close c_detfactors;
451: End If;

Line 553: From Dual;

549: Select zx_rules_b_s.nextval,
550: zx_condition_groups_b_s.nextval
551: Into l_rule_id,
552: l_cg_id
553: From Dual;
554: INSERT ALL
555: WHEN (1=1) Then
556: INTO zx_sim_rules_b (
557: sim_tax_rule_id,

Line 614: FROM dual

610: fnd_global.user_id created_by,
611: sysdate creation_date,
612: fnd_global.user_id last_updated_by,
613: sysdate last_update_date
614: FROM dual
615: WHERE exists (Select 1
616: from zx_sim_conditions
617: where applicability_flag='Y');
618:

Line 679: From Dual;

675: Select zx_rules_b_s.nextval,
676: zx_condition_groups_b_s.nextval
677: Into l_rule_id,
678: l_cg_id
679: From Dual;
680:
681: INSERT ALL
682: WHEN (1=1) Then
683: INTO zx_sim_rules_b (

Line 741: FROM dual

737: fnd_global.user_id created_by,
738: sysdate creation_date,
739: fnd_global.user_id last_updated_by,
740: sysdate last_update_date
741: FROM dual
742: WHERE exists (Select 1
743: from zx_sim_conditions
744: where status_determine_flag='Y');
745:

Line 799: From Dual;

795: Select zx_rules_b_s.nextval,
796: zx_condition_groups_b_s.nextval
797: Into l_rule_id,
798: l_cg_id
799: From Dual;
800: INSERT ALL
801: WHEN (1=1) Then
802: INTO zx_sim_rules_b (
803: sim_tax_rule_id,

Line 862: FROM dual

858: fnd_global.user_id created_by,
859: sysdate creation_date,
860: fnd_global.user_id last_updated_by,
861: sysdate last_update_date
862: FROM dual
863: WHERE exists (Select 1
864: from zx_sim_conditions
865: where rate_determine_flag='Y');
866: