APPS.CZ_IMP_ALL dependencies on CZ_XFR_PROJECT_BILLS_S

Line 752: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id

748: END;
749:
750: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,
751: copy_addl_child_models,source_server)
752: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
753: from dual where not exists
754: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and
755: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id);
756: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS

Line 756: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS

752: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
753: from dual where not exists
754: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and
755: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id);
756: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS
757: where organization_id=nOrg_ID and
758: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id;
759: COMMIT;
760: EXCEPTION

Line 794: update cz_xfr_project_bills set

790: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
791: RAISE;
792: END;
793:
794: update cz_xfr_project_bills set
795: deleted_flag=DECODE(UPPER(sState),'0','1','OFF','1','NO','1','DISABLE','1',
796: '1','0','ON','0','YES','0','ENABLE','0',DELETED_FLAG)
797: where organization_id=nOrg_ID and top_item_id=nTop_ID and explosion_type='OPTIONAL' AND
798: source_server = server_id;

Line 847: update cz_xfr_project_bills set

843: AND organization_id = nOrg_ID
844: AND concatenated_segments = sTop_ID
845: AND rownum = 1;
846:
847: update cz_xfr_project_bills set
848: deleted_flag='1'
849: where organization_id=nOrg_ID and top_item_id=nTop_ID
850: and source_server = server_id;
851: